Azure App Service
Azure App Service is a service used to create and deploy scalable, mission-critical web apps.
For anyone developing in Visual Studio the answer is to uncheck Prefer 32-bit in the project properties compile page.
How to fix The microsoft.ACE.OLEDB.12.0 provider is not registered on the local machine (Azure) for Access Database
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(262.40000000000003, 70%, 35%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EEC%3C/text%3E%3C/svg%3E)
Ed Choi
60
Reputation points
Connection to ACCESS database fails with exception:
The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine
Azure App Service
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(185.6, 59%, 27%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESM%3C/text%3E%3C/svg%3E)
SnehaAgrawal-MSFT 22,721 Reputation points Moderator2023-06-27T07:10:59.3066667+00:00 Thanks for reaching here! Could you please elaborate your issue in detail and Azure services you are using.
-
Olaf Helper 47,616 Reputation points2023-06-27T07:14:23.0033333+00:00 How to fix The microsoft.ACE.OLEDB.12.0 provider
You fix it by installing the ACE = "Access Database Runtime" dataprovider, select the right version from below:
https://www.microsoft.com/en-us/download/details.aspx?id=10910
https://www.microsoft.com/en-us/download/details.aspx?id=39358
https://www.microsoft.com/en-us/download/details.aspx?id=54920
-
Ed Choi 60 Reputation points
2023-06-27T13:21:06.47+00:00 After developing an ASP.NET VB web application using ACCESS database on Visual Studio 2022, successfully deployed to an Azure App Service. The app was functioning, but failed with exception when connecting to the ACCESS database.
Exception:
The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine
Since the application is hosted at azure app service, unable to download the required modules and register. Using different options of deploying from Visual Studio 2022 were of no help either.
-
Ed Choi 60 Reputation points
2023-06-27T13:52:53.2133333+00:00 As to Olaf Helper's advice, I downloaded AccessRuntim.exe (32 bit) and installed on my PC, rebuilt my app on Visual Studio 2022 and deployed to Azure web service, but it still fails the connection to ACCESS database at Azure.
-
Ed Choi 60 Reputation points
2023-06-28T18:48:25.48+00:00 After reading some articles posted, I found that ACCESS database run-time DLLS such as Microsoft.ACE.Oledb.12.0.dll and ACEOLEDB.DLL were not deployed (from Visual Studio 2022) to the application folder at Azure. I was wondering if this may be the cause of ACCESS database connection failure...
-
Ed Choi 60 Reputation points
2023-06-29T17:49:52.34+00:00 Found oledb32.dll in the following azure active directories:
d:\Program Files\Common Files\System\Ole DB\oledb32.dll
d:\Program Files\Common Files\System\Ole DB\oledb32r.dll
d:\Program Files\Common Files (x86)\System\Ole DB\oledb32.dll
d:\Program Files\Common Files (x86)\System\Ole DB\oledb32r.dll
But command "regsvr32 oledb32.dll" fails with "Access is denied" even the option for "user can register application" is turned on.
-
Ed Choi 60 Reputation points
2023-06-29T18:27:46.84+00:00 Besides, there are no ACEOLEDB.DLL and Microsoft.ACE.Oledb.12.0.dll found on the Azure directories.
Sign in to comment
4 answers
Sort by: Most helpful
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(41.6, 47%, 14%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EVM%3C/text%3E%3C/svg%3E)
Val Macduff 50 Reputation points2024-03-05T07:24:10.1933333+00:00 -
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(304, 51%, 39%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDG%3C/text%3E%3C/svg%3E)
Devin Gillotti 5 Reputation points2024-11-10T05:07:01.76+00:00 Thank you, out of all those long complicated solutions your very simple fix worked.
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(246.4, 12%, 33%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECC%3C/text%3E%3C/svg%3E)
Cliff Crawford 0 Reputation points2025-01-06T21:50:02.0766667+00:00 Thank you. I knew the issue was because I built my project on a machine with 32 bit and I was trying to run the compiled exe on a machine with 64 bit. However, I did not know there was such a simple fix for this issue.
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(137.6, 36%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESY%3C/text%3E%3C/svg%3E)
Sean Yamzon 0 Reputation points2025-10-30T16:27:37.9533333+00:00 Thank you so much, you are a lifesaver!!!! <33333
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(83.2, 15%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ES%3C/text%3E%3C/svg%3E)
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(185.6, 44%, 27%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAR%3C/text%3E%3C/svg%3E)
Andrew Roberts 0 Reputation points2026-01-26T13:16:18.7966667+00:00 Finally got the project to run! Thanks for this, couldn't work out why it was running on my other projects but not the problem one. Solved!!!
Sign in to comment -
-
Ed Choi 60 Reputation points
2023-07-02T15:38:43.9933333+00:00 Problem
ACCESS database connection failure on an app in Azure Web Service:
The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine
The 'Microsoft.Jet.Ole8db.4.0' provider is not registered on the local machine.
Background
Microsoft recognizes that the error is by design as we do not install the Microsoft.Ace.we.12.0' driver. The Microsoft.Ace drivers are not supported in server side environments and as of now there is no plans to add these to the Azure Web Sites.
My working solution
The solution is complex, but it is working at least.
Step 1) Separate connection strings for the 64-bit source (on PC) and 32-bit target (Azure)
Connection String for 64-bit environment:
"Provider=Microsoft.ACE.OLEDB.12.0;" & "Data Source=" & sMdb & ";" & "Jet OLEDB:Database Password=" & sPass & ";" & "Persist Security Info=True;"
Connection String for 32-bit target environment:
"Provider=Microsoft.Jet.Ole8db.4.0;" & "Data Source=" & sMdb & ";" & "Jet OLEDB:Database Password=" & sPass & ";" & "Persist Security Info=True;"
Step 2) Adjust Registry Editor
In the search box on the taskbar, type “regedit” to open Registry Editor and adjust
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Fusion
Add:
DWORD ForceLog set value to 1
DWORD LogFailures set value to 1
DWORD LogResourceBinds set value to 1
DWORD EnableLog set value to 1
String LogPath set value to folder for logs (e.g. C:\FusionLog)
(reference: https://stackoverflow.com/questions/255669/how-to-enable-assembly-bind-failure-logging-fusion-in-net)
Step 3) Switch settings when deploying to Azure
- Compiler settings
Change Project / Property / Compile / Target CPU to “x86”
- Menu bar - Build / Configuration Manager
Change Platform to "x86"
- IIS – Application Pools
Change Enable 320Bit Applications to “True”
Step 4) Switch settings back to 64-bit development PC environment
- Compiler settings
Change Project / Property / Compile / Target CPU to “Any CPU”
- Menu bar - Build / Configuration Manager
Change Platform to "Any CPU"
- IIS – Application Pools
Change Enable 320Bit Applications to “False”
-
Ed Choi 60 Reputation points
2023-07-04T11:27:06.2933333+00:00 My working solution failed again after reinstalling Office 365 and Azure Virtual Machine.
I am not sure if ACCESS would be a reliable data source in the Azure environment.
-
SnehaAgrawal-MSFT 22,721 Reputation points Moderator
2023-07-04T15:16:54.2166667+00:00 @Ed Choi Could you please reach out to us by sending an email with subject line “Attn:Sneha |thread title” to AzCommunity[at]microsoft[dot]com referencing this thread, would be working closely on this.
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(147.20000000000002, 54%, 24%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPC%3C/text%3E%3C/svg%3E)
Phil Caldwell 0 Reputation points2023-12-09T08:15:57.14+00:00 I had all sorts of difficulty trying to connect local (not Azure) MS Access databases to a DataGridView with the above error until i read Step 4) above and reconfigured my compiler to x64 - then it worked.
Sign in to comment -
TT 85 Reputation points2024-09-09T22:11:26.6766667+00:00 The Wayback Machine and Internet Archive FOR THE WIN!
This was sourced from chocolatey, but is available for direct download from the following links:
Chocolately package for reference: https://community.chocolatey.org/packages/made2010#files
Cheers!
-
SnehaAgrawal-MSFT 22,721 Reputation points Moderator
2023-06-30T06:04:46.86+00:00 Apologies for facing issue on this! If you are receiving the following error on your Azure Web Site
'Microsoft.Ace.OLEDB.12.0' provider is not registered on the local machine
The error is by design as we do not install the Microsoft.Ace.we.12.0' driver.
The Microsoft.Ace drivers are not supported in server side environments and as of now there is no plans to add these to the Azure Web Sites.Workaround-
This leaves the option of using the Jet Drivers which are installed, however these are only available in 32 bit versions so you will have to configure your site to run in 32 bit versions. The Microsoft OLE DB Provider for Jet and the Microsoft Access ODBC driver are available in 32-bit versions only: http://support.microsoft.com/kb/957570/en-us
This is also discussed here: Data Access Technologies Road Map http://msdn.microsoft.com/en-us/library/ms810810.aspx#bkmk_DepMDAC_WDACComps
Also, you could use Windows Containers to install these drivers.
Quickstart: Run a custom container on App Service - Azure App Service | Microsoft LearnFurther if you wish you may share your feedback on Azure Web App Uservoice -
All of the feedback, you share in these forums will be monitored and reviewed by the Microsoft engineering teams responsible for building Azure. Additionally, users with a similar request can up-vote you post and add their comments.
Please let us know, if you have further query or issue remains.
-
Ed Choi 60 Reputation points
2023-06-30T22:44:29.4866667+00:00 As you indicated, I ran “accessdatabaseengine.exe” (from 2016)
https://www.microsoft.com/en-us/download/details.aspx?id=54920.
But it failed with error (attached)32-bit install error.jpg:
As the error message indicated, I removed 64-bit Office products and re-ran “accessdatabaseengine.exe”. But I got the same error message.
2)
I installed “accessRuntime.exe” (from 2010)
https://www.microsoft.com/en-us/download/details.aspx?id=10910, adjusted the connection string, rebuilt, and re-published.
But it failed as below:
ConnectionString:
"Provider=Microsoft.Jet.Ole8db.4.0;" & "Data Source=" & sMdb & ";" & "Jet OLEDB:Database Password=" & sPass & ";" & "Persist Security Info=True;"
=> exception
The 'Microsoft.Jet.Ole8db.4.0' provider is not registered on the local machine
3)
I even tried with the connection string for ODBC, but it still fails with the exception:
An OLE DB Provider was not specified in the ConnectionString. An example would be, 'Provider=SQLOLEDB;'.
Your help is much appreciated.
-
Ed Choi 60 Reputation points
2023-07-01T13:26:29.4+00:00 As per some articles posted, “AccessDatabaseEngine.exe” from Microsoft Access Database Engine 2010 Redistributable https://www.microsoft.com/en-ca/download/details.aspx?id=13255 was successfully installed, but the ACCESS database connection still fails with the same error:
ConnectionString = "Provider=Microsoft.Jet.Ole8db.4.0;" & "Data Source=" & sMdb & ";" & "Jet OLEDB:Database Password=" & sPass & ";" & "Persist Security Info=True;"
=> exception
The 'Microsoft.Jet.Ole8db.4.0' provider is not registered on the local machine
Note: Target CPU was set to 86x when deploying (screenshot attached)
-
Ed Choi 60 Reputation points
2023-07-02T00:51:46.8733333+00:00 Found that DLLs of Microsoft Jet OLE DB 4.0 reside on C:\Windows\System32. Tried to register the DLLs by executing command such as “regsvr32 Msjetoledb40.dll”, but failed with error “Access was denied” even I was using the admin account with the right permissions. (screen-print attached)
Sign in to comment -