Microsoft Access Database Support on your server

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

Would you like to...

Print this page Print this page

Email this page Email this page

Post a comment Post a comment

Subscribe me

Add to favorites Add to favorites

Remove Highlighting Remove Highlighting

Edit this Question

User Opinions (2 votes)

100% thumbs up 0% thumbs down

How would you rate this answer?

  • Helpful
  • Not helpful