Connect to MS Access Database - Hostingsaloon.com - Knowledgebase

Connect to MS Access Database

Connect to MS Access Database

 
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
  • 0 Users Found This Useful
Was this answer helpful?

Related Articles

Connection String for MS Access

Connection String for MS Access   Connection String is a string which contains database...