Home>Knowledge Base>Scripting>How do i connect to an Access database?
User Login
Username
Password
 
 Login
Information
Article ID19
Created On4/12/2006
Modified8/18/2008

How do i connect to an Access database?

An example connection string to an MS Access database is below:-

Set Conn = Server.CreateObject("ADODB.Connection")
conString = "Data Source=D:\domains\yourdomain.com\db\database.mdb"
Conn.Open "Provider=Microsoft.Jet.OLEDB.4.0;" & conString