If you are trying to use the accdb access database in your web application, you may run into this error when making your connection call to open the database in your script.
Issue Details
Using the ACCDB access database, you will have to download and install the driver on your server if you do not have Microsoft Office 2007 or Microsoft Office 2010 installed on the server on which the script is being run.
The following error will happen if you do not have the driver installed.
Dated: June 26, 2026 The information in this article is for historical purposes only. All Microsoft URLs are no longer valid. They are being left here for historical purposes. Drivers for Office ACCESS are no longer supported on newer Windows Servers, especially Server Core. This KB Article is for Historical reading, not to be used in a productive environment anymore.
ADODB.Connection error '800a0e7a' Provider cannot be found. It may not be properly installed. /ACN.asp, line 15
Recreate Issue
[Scenario #1:]
Do not have any drivers installed for the Access Database; this will cause this error.
[Scenario #2:]
The [application pool] is not configured to run 32-bit.
Resolve Issue
[Scenario #1:]
Either install Microsoft Office 2007 or Microsoft Office 2010. If they are unavailable, you will need to download and install the following driver.
www.microsoft.com/download/en/details.aspx?id=13255 - Microsoft Access Database Engine 2010 Redistributable
[Scenario #2:] Open [IIS] (Internet Information Services) [Step #1] Click on [Application Pools] Either create a [New Application Pool] by right-clicking and choosing such (or) [Right Click] on one of the available Application Pools If this is for [ASP Classic], make sure that you choose the one that has Classic under [Managed Pipeline]. [Next][Right Click] on the chosen Application Pool name, and choose [Advanced Settings] Under [General] Enable 32-Bit Applications [True] Click [OK][Step #2] Expand [Server Name] Expand [Sites][Right Click] on the [Default Web Site] (or) the website you are working with. Hover the cursor over: [Manage site] Then choose [Advanced Settings] (This can also be gotten to by the following) Click on the [Default Web Site] On the far right panel Under [Browse Web Site] Click [Advanced Settings] When the Advanced Settings Dialog opens. Under [General][Application Pool] Choose the Application Pool name from the dropdown list that you assigned 32-Bit to in [Step #1]. Click [OK] Then reload your page.
Scenario #3: Perform this after everything else above has been done.
%windir%\system32\inetsrv\appcmd set config -section:applicationPools -applicationPoolDefaults.enable32BitAppOnWin64:true
Scenario #4 Download the www.microsoft.com/en-us/download/details.aspx?id=13255 - Microsoft Access Database Engine 2010 Redistributable package. Choose the 32-Bit version. To install this 32-Bit file on your 64-Bit server, you will need to perform the following.
Use the /passive
Copy
Search Site
Search Google
parameter with the 64-bit version. (This information was provided by: Ivana Kolin from Solidworks.com« ) You can also watch the following Video, which demonstrates this method as well. from here [youtube]qG60Aa9q-s8[/YouTube][codevalue]Click Start, then click Run. In the Run dialog box, type cmd, and then click OK. In the command prompt window, change the Directory to the drive that contains the downloaded AccessDatabaseEngine.exe
Copy
Search Site
Search Google
To change the Directory, type in the Drive letter and colon, and press [Enter]. Example - D: To change folder locations to where you have the AccessDatabaseEngine located.