• Choose the System DSN tab.
• Select the Microsoft Access Driver. Click Finish. 5. In the next screen, click Select to locate the database.
• Give the database a Data Source Name (DSN).
• Click OK.

Note that this configuration has to be done on the computer where your web site is located. If you are running Personal Web Server (PWS) or Internet Information Server (IIS) on your own computer, the instructions above will work, but if your web site is located on a remote server, you have to have physical access to that server, or ask your web host to do this for you.

The ADO Connection object is used to create an open connection to a data source. Through this connection, you can access and manipulate a database.

After an ADO Database Connection has been created, as demonstrated in the previous chapter, it is possible to create an ADO Recordset.

We may use SQL to specify how to sort the data in the record set.