ACC97: Action Queries Cannot Be Exported to HTML, IDC, or ASP

1. Start Microsoft Access 97 and open the sample database Northwind.mdb.
2. Create the following new query called EnterShipper based on the Shippers table:
   

           Query: EnterShipper
           -------------------
           Type: Select Query
   
           Field: CompanyName
             Table: Shippers
   						

3. On the Query menu, click Parameters.
4. Type the following in the Query Parameters dialog box, and then click OK.
   

           Parameter          Data Type
           ----------------------------
           [EnterName]        Text
   						

5. Save the EnterShipper query and close it.
6. Select the EnterShipper query in the Database window, and then click Save As/Export on the File menu.
7. In the Save As dialog box, click "To an External File or Database," and then click OK.
8. In the "Save Query 'EnterShipper' In" dialog box, select Microsoft IIS 1-2 (*.htx;*.idc) in the Save As Type box, and type EnterShipper.htx in the File Name box. Note the folder where the exported files will be stored. Click Export.
9. In the HTX/IDC Output Options dialog box, type the name of a System DSN on your Web server that points to the Northwind sample database. Click OK.
   
   For more information on how to define a system DSN, search the Help index for "ODBC, setting up data sources," and see the following article in the Microsoft Knowledge Base:
   
   159682 ACC97: "Data Source Name Not Found" Err Msg Opening Web Page
10. Click OK in the Enter Parameter Value dialog box that appears.
11. The HTX/IDC output creates three files: EnterShipper.HTML, EnterShipper.htx, and EnterShipper.IDC.
12. Copy EnterShipper.HTML, EnterShipper.htx, and EnterShipper.IDC to a folder on your Web server computer where you have both Read and Execute permission. Read permission is necessary to browse the HTML file, and Execute permission is necessary to run the IDC file.
    
    For more information about configuring Microsoft Internet Information Server (IIS) permissions, please refer to the IIS Help Index, and see the following article in the Microsoft Knowledge Base:
    
    160754 ACC97: Error "HTTP/1.0 403 Access Forbidden" Browsing IDC Page

Customizing the IDC files to Permit Inserting Records

1. Use Notepad or another text editor to open the EnterShipper.IDC file. You need to change the SQL Statement so that it will use the value passed from the HTML form and insert it into the Shippers table of the Northwind sample database. Change the SQL Statement so that it looks like this:
   

          INSERT into Shippers (CompanyName) values ('%[EnterName]%');
   						

2. Save the EnterShipper.IDC file and close it.
3. Start Microsoft Internet Explorer 3.0, or another Web browser program.
4. Type the Uniform Resource Locator (URL) in the address box of your Web browser to view EnterShipper.HTML. For example, if you saved your IDC files in a folder called Test in the wwwroot folder of your Web server, type:
   
   http://<servername>/test/EnterShipper.HTML
   
   Note that the URL depends upon where your files are located on the Web Server.
5. The EnterShipper.HTML form opens in your Web browser with an [EnterName] box and a Run Query button. Type a name into the box, and then click the Run Query button. A new record with the name you typed is inserted into the Shippers table in the Northwind sample database. Note that no records are returned to your web browser because an insert query does not return records.