Microsoft Access database support is available on Business web hosting package, and higher. Please note, your website needs to be placed on the Windows server, in order to support Microsoft Access database.
To have support for MS Access databases enabled, once your website is on the Windows server, please upload your database to a folder on your website directory via FTP.
Please find an example of a DSN connection string below:
dim conn, connStr
connStr = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source="& request.servervariables("APPL_PHYSICAL_PATH") & "CHANGETHISTODATABASE.mdb;"
'Create the Connection Object Set conn = Server.CreateObject("ADODB.Connection") conn.ConnectionTimeout = 30 conn.CommandTimeout = 30
'Open the Connection object conn.Open connStr