Active Server Pages allows you to interact with any ODBC-compliant database, be it SQL Server, Access, Oracle, or Informix. Often times developers are connecting to a SQL Server database, but there are many who are connecting to Access databases as well. This article, written by Gary Van Sluis, describes how to connect to an Access database.
For the accompanying source code to work, you will need to implement the following steps:
1.) Create ODBC Settings wtih DSN name = Northwind
2.) Copy "Employee Sales By Country" Query and Rename it to "Employee" (had some problems with spaces in names so I use just one name with no spaces)
3.) Cut and pasted following code samples to two pages (proc.asp) and (proc2.asp)
4.) And sample away
There are two files which you will need: Proc.asp and Proc2.asp. Here is the source code:
Proc.zip
Proc2.zip