Can not connect to MS Access database.
Doka only provides DSN-less connection to the Access databases, because they
are much faster and there is no possible name conflicts.
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=" &
And the way to useit:
ConnectionString = "PROVIDER=MICROSOFT.JET.OLEDB.4.0;DATA
SOURCE=" & Server.MapPath("Database\TestDB.mdb")
Set DbConnection =