Connect to MS Access Database Using DSN-less Connection

Doka only provides DSN-less connections to Access databases because they are much faster and eliminate the possibility of name conflicts.

Most problems arise from choosing the correct connection string. Here is an example of a tested connection string for an MS Access database:

We assume that your database resides in the “Database” subfolder and its name is “TestDB.mdb”.

You will have to use Server.MapPath("Database\TestDB.mdb") to get the physical location of the database.

So, the connection string would be:

"PROVIDER=MICROSOFT.JET.OLEDB.4.0;DATA SOURCE=" & Server.MapPath("Database\TestDB.mdb")

And here's how to utilize it:

ConnectionString = "PROVIDER=MICROSOFT.JET.OLEDB.4.0;DATA SOURCE=" & Server.MapPath("Database\TestDB.mdb")

Set DbConnection = Server.CreateObject("ADODB.Connection")

DbConnection.Open ConnectionString