| Your Application Bitness | Required Provider Bitness | Typical Error if Mismatched | |--------------------------|---------------------------|-----------------------------| | 32-bit (e.g., old VB6 app) | 32-bit ACE.OLEDB.12.0 | "Provider not registered" | | 64-bit (e.g., SQL Server 2016+) | 64-bit ACE.OLEDB.12.0 | "Provider not registered" | | 64-bit PowerShell | 64-bit ACE.OLEDB.12.0 | "Cannot load" |
The /passive switch tells the installer to run with progress bars but not to display error dialogs. It forces the installation to complete, allowing the 32-bit DLLs to coexist with the 64-bit ones. Both providers will now be registered. download microsoft.ace.oledb.12.0 provider for both 64-bit
To obtain the Microsoft.ACE.OLEDB.12.0 provider for a system, you must download and install the Microsoft Access Database Engine Redistributable | Your Application Bitness | Required Provider Bitness