Connection String
“Provider=MSDASQL;DRIVER={Microsoft Access Driver (*.mdb)};” &_”UID=;PWD=YourPassword;” &_

“DBQ=DatabasePhysicalPath;”


You can use sample code below to connect to your MS Access’s database:

ConnectionString = “Provider=MSDASQL;DRIVER={Microsoft Access Driver (*.mdb)};” &_
                   “UID=;PWD=SamplePassword;” &_
                   “DBQ=C:\Domains\sample.net\db\sample.mdb;”


Set Conn = Server.CreateObject(”ADODB.Connection”)
Conn.ConnectionString = ConnectionString
Conn.Open