Support: Hosting

Return to Shared

How to connect your ASP application to a Microsoft Access database.

Before your website can access your Microsoft Access database, your web application needs to connect to it using either OLE-DB or ODBC.

Microsoft Access 2000 Database (OLE-DB):

Set db = Server.CreateObject("ADODB.Connection") db.Open "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" & Server.MapPath("database.mdb") & ";"

Microsoft Access 2000 Database:

Set db = Server.CreateObject("ADODB.Connection") db.Open "DRIVER={Microsoft Access Driver (*.mdb)};DBQ=" & Server.MapPath("database.mdb") & ";UID=;PWD="