Connect to MS Access Database

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


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;" &_


Set Conn = Server.CreateObject("ADODB.Connection")
Conn.ConnectionString = ConnectionString

Did you find it helpful? Yes No

Send feedback
Sorry we couldn't be helpful. Help us improve this article with your feedback.