Set up the server folder and ASP files

After installing PWS or IIS, you should create a new folder to store the database and ASP files that you’ll execute in order to retrieve data from that database. Create the new folder in \inetpub\wwwroot and name it sample.

Then copy the Northwind sample database that comes with Access into this new folder. You will find the Northwind.mdb file in \Program Files\Microsoft Office\Office\Samples. If you can’t locate Northwind.mdb, use the Windows Find feature or insert your Office CD and install it.

By default, a folder won’t share files. So after you’ve created the sample folder, right-click its icon in Windows Explorer, select Properties, then click the Web Sharing tab. Select the Share This Folder option and click OK. Now Windows will allow you to share the files within this folder on a network.

Create the example ASP Files

The three links below open three short ASP example scripts. To create these files, simply copy and paste each script into Notepad as an individual file. Save each as an ASP file by manually adding the .asp extension to the file’s name. For instance, to save the first script, choose Save As from the File menu, select All Files(*.*) from the Save AS Type control, then enter the filename example1.asp. Put all three ASP files in the \inetpub\wwwroot\sample folder you created.

  1. Example1.asp
  2. Example2.asp
  3. Example3.asp

Click Next for create a DSN connection.