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 A felhasználók hasznosnak találták ezt
Hasznosnak találta ezt a választ?

Related Articles

Microsoft Access .LDB File

The server must have access to the database to read / write information. When the server or user...

Connect to MS SQL Server Database

Connection String "Provider=SQLOLEDB; " & _"Data Source =...