A couple of good articles have already been written which describe how to connect to a database. These articles are available at the bottom of this article. Before you read on, let me give a quick overview.
Connecting to a Database:
1.) Create a system DSN using the ODBC Wizard in the Control Panel
2.) Connect to the database using a simple connection string: "DSN=System DSN Name"
1.) Place the Access database file (the *.mdb file) in a web-shared directory
2.) The connection string is a bit more complex. You need to specify two things: the driver and the physical location of the file (i.e.:
(If the above makes absolutely no sense to you, don't worry, just read through these articles!)
Database Connectivity Articles: