Creating Dynamic Web Pages with Microsoft Access

At this point you need to provide a name for your file. We'll call ours Products. Also, you should use the file browser to locate the path to publish your file. This will depend upon your web server. The default path for IIS is \Inetpub\wwwroot. Once you've completed this step click the Save All button.

The Microsoft ASP Output Options dialog box allows you to specify the details of your ASPs. First, you can choose a template to provide formatting. Some sample templates are stored in the directory \Program Files\Microsoft Office\Templates\1033\. We'll use the "Simple Layout.htm" in this example.

The next entry is the Data Source Name. It's important to remember the value you enter here -- it defines the connection used by the server to access the database. You can use any name here; we'll set up the connection in a few minutes. Let's call our Data Source "Northwind."

The final section of our dialog box allows us to specify the URL and timeout values for the ASP. The URL is the method by which our ASP will be accessed over the Internet. You should enter a value here that corresponds to the file name and path you selected in step 5. If you placed the file in the wwwroot directory, the URL value is "http://yourhost.com/Products.asp", where yourhost is the name of your machine (i.e. databases.about.com or www.foo.com). The timeout value allows you to specify how long a connection will be left open for an idle user. Five minutes is a good starting point.