Using Access database on a 64-bit hosting environment

When connecting to an Access database on an IIS server where the site's worker process runs as 64-bit, the 32-bit JET driver will not function:

Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\path\to\access.mdb

Your connection string will need to be updated to use the 64-bit ACE driver:

Provider=Microsoft.ACE.OLEDB.12.0;Persist Security Info=False;Data Source=C:\path\to\access.mdb
  • Access
  • 0 Users Found This Useful
Was this answer helpful?

Related Articles

Redirect non-SSL to SSL in Linux (Apache)

Create a file .htaccess in the document root of your site with the following code.  If this file...

Redirect non-SSL to SSL in Windows (IIS)

The following code sample will 301-redirect to...

How do I redirect my site using a .htaccess file?

Note: Applies to Linux hosting accounts only. Create an empty text file using a text editor such...

Enable custom error pages on IIS 7 (Windows 2008) and newer

Custom error pages can be implemented in IIS 7 (Windows 2008) and newer by placing a web.config...

Remotely view error messages on IIS 7 (Windows 2008) and newer

When a website page encounters a coding error on a IIS 7 (Windows 2008) or newer hosting server,...