Publish server-generated HTML files to a Web server

To use server-generated HTML files (either ASP or IDC/HTX) on a Web server, you need to do the following.

1. Install the appropriate software on the computer that will be the Web server and that will process the server-generated HTML files.
   
   
2. Create a folder under the root directory to contain the ASP or IDC/HTX files. The default root directory is \Webshare\Wwwroot for Personal Web Server and \Inetpub\Wwwroot for Microsoft Internet Information Server.
   
   
3. Define the appropriate privileges for the folder   Execute for Windows NT 4.0 or later and Execute Scripts for Windows 95 or later. For more information about sharing a folder, see Windows Help.
   
   
4. Copy the ASP or IDC/HTX files to the folder. Copy related files such as graphics, linked files, and any folders that may contain these files to the folder, or make sure the related files can be located by the Web server software. Learn about managing Web pages and links.
   
   
5. Either copy the Microsoft Access database or Microsoft SQL Server database to the folder, or define its network location in the ODBC data source definition in step 6.
   
   
6. Define the ODBC data source as a System DSN on the Web server. Make sure that the data source name is the same name as the one you entered in the appropriate Output Options dialog box when you output the ASP or IDC/HTX files. Learn about defining an ODBC data source.
   
   
7. If desired, define database security for the ODBC data source, but ensure that users can access the ODBC data source.

   For a Microsoft Access database, create a user-level security username and password to allow users to access the Access database from the Web page. If you do not create a user-level security username or password, the default username is Admin, and no password is used. Learn about user-level security in an Access database.

   For a Microsoft Access project, in the Username and Password boxes, create a database username and password to allow users to access the Microsoft SQL Server database from the Web page. If you do not create a username or password, the default username is Sa, and no password is used. Learn about SQL Server database security.

   The username and password must match the username and password that you enter in the User to Connect As and Password for User boxes of the Microsoft Active Server Pages Output Options or HTX/IDC Output Options dialog boxes that appear when you output the ASP or IDC/HTX files.

Note   If you need to export multiple datasheets, you can automate the operation by creating a macro or creating a Visual Basic for Applications program. This is particularly useful when you frequently export datasheets to test and build a Web site.