Wednesday, June 12, 2013

The Microsoft.ACE.OLEDB.12.0 provider is not registered on the local machine

MS-Access 2010 for VB 2010

Visual Basic 2010 Error Message :

InvalidOperationException was unhandled" The Microsoft.ACE.OLEDB.12.0 provider is not registered on the local machine" ?

This error message means that the machine [Computer, Laptop] that you are trying to run your application on, doesn't have MS-Access 2007 installed, or not installed properly. Some developers just pack their applications and send it to the client :

- relying on - that the client have MS-Office 2007/2010 installed already and won't never crash or updated to 2010,

- or they just did not include the proper component along with their package,

- or even worse they may not know what exactly should they do to make it work on the client's machine.

╚╣ To get this error message to go away, you need to include this file in your package :

Some think that Office 2007 should be installed on a client's machine in order for the application to run clean or properly with any bugs, No, you can include this tool for both [Win32 and Win64] and don't count the client to have Office installed or not.

Get the file from here [AccessDatabaseEngine] for both Win64bit and Win32bit, available in all languages supported by Microsoft. Here are some information about downloading and installing the tool :

You could see a reference to Office 2010, don't panic, this is the same, it's the same tool that supports also Office 2010. If your application relies on MS-Access 2010 Database and you got the same meaningful Error message then the same cause needs to be fixed by including this very same file into your package without relying on the client's machine to have MS-Office 2010 or MS-Access 2010 installed on it.

Thank you for downloading

Microsoft Access Database Engine 2010 Redistributable

After the download finishes, pick up the corresponding file that meets your OS kind [32 or 64]

If you are an application developer using ODBC to connect to
Microsoft Office Access data, set the Connection String to
“Driver={Microsoft Access Driver (*.mdb, *.accdb)};DBQ=path to mdb/accdb
file”

If you are an application developer using ODBC to connect to
Microsoft Office Excel data, set the Connection String to
“Driver={Microsoft Excel Driver (*.xls, *.xlsx, *.xlsm,
*.xlsb)};DBQ=path to xls/xlsx/xlsm/xlsb file”

To remove this download:
To remove the download file itself, delete the file AccessDatabaseEngine.exe

On the Start menu, point to Settings and then click Control Panel.

Double-click Add/Remove Programs.

In the list of currently installed programs, select “Microsoft Access database engine 2010” and then click Remove or Add/Remove. If a dialog box appears, follow the instructions to remove the program.

Click Yes or OK to confirm that you want to remove the program.

Additional Information

This package contains components that are at the
same version as the “The 2007 Microsoft Office Suite Service Pack 1
(SP1)” release.

The Office System Drivers are only supported under certain scenarios, including:

Desktop applications which read from and write to various files
formats including Microsoft Office Access, Microsoft Office Excel and
text files.

To transfer data between supported file formats and a database
repository, such as SQL Server. For example, to transfer data from an
Excel workbook into SQL Server using the SQL Server Import and Export
Wizard or SQL Server Integration Services (provided the SSIS jobs run in
the context of a logged-on user with a valid HKEY_CURRENT_USER registry
hive).