Your Trusted Hosting Solutions Partner > Knowledgebase > Database > MS Access > 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

Add to Favourites    Print this Article

Connection String for MS Access (Views: 7189)