Connect to MS access database usin DSN-less connection
Doka only provides DSN-less connection to the Access databases, because they
are much faster and there is no possible names conflict.
Most of the
problems are in choosing right connection string. Here is an example of tested
connection string to MS Access database:
We suppose that your
database resides in “Database” subfolder and it name is “TestDB.mdb”.
You’ll have to use Server.MapPath(“Database\TestDB.mdb”) in order to get
physical location of database.
So connection string would be:
"PROVIDER=MICROSOFT.JET.OLEDB.4.0;DATA SOURCE=" &
Server.MapPath("Database\TestDB.mdb")
And the way 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