Visual Basic Online Course - The Microsoft.ACE.OLEDB.12.0 provider is not registered on the local machine

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 :

2007 Microsoft Office System Update: Redistributable Primary Interop Assemblies

 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 :

When you first click on Download on the Download page, you will see :

Choose the download you want

File Name

AccessDatabaseEngine.exe	25.6 MB
AccessDatabaseEngine_x64.exe	28.1 MB

The download should start for selected file ...

The 2007 Microsoft Office system Primary Interop Assemblies (PIA) redistributable is a Microsoft Windows Installer package that contains the Primary Interop Assemblies for 2007 Microsoft Office system products.

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.

• Microsoft Access Database Engine 2010 Redistributable

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

  ♥ Installation Instructions ♥

  To install this download:
  

  1. Download the file by clicking the Download button and saving the file to your hard disk.
  2. Double-click the AccessDatabaseEngine.exe program file on your hard disk to start the setup program.
  3. Follow the instructions on the screen to complete the installation.

  To use this download:
  

  1. If you are the user of an application, consult your application documentation for details on how to use the appropriate driver.
  2. If you are an application developer using OLEDB, set the Provider argument of the ConnectionString property to “Microsoft.ACE.OLEDB.12.0”
     
     If you are connecting to Microsoft Office Excel data, add the appropriate Extended Properties of the OLEDB connection string based on the Excel file type:
     
     File Type (extension)                                             Extended Properties
     ---------------------------------------------------------------------------------------------
     Excel 97-2003 Workbook (.xls)                                  "Excel 8.0"
     Excel 2007-2010 Workbook (.xlsx)                             "Excel 12.0 Xml"
     Excel 2007-2010 Macro-enabled workbook (.xlsm)      "Excel 12.0 Macro"
     Excel 2007-2010 Non-XML binary workbook (.xlsb)      "Excel 12.0"
     
     
  3. 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”
  4. 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
  

  1. On the Start menu, point to Settings and then click Control Panel.
  2. Double-click Add/Remove Programs.
  3. 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.
  4. 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:
  
  
  1. Desktop applications which read from and write to various files formats including Microsoft Office Access, Microsoft Office Excel and text files.
  2. 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).

 Source for Installation instruction (Microsoft)

---

♥ Here are some online Visual Basic lessons and courses :

• Visual Basic .Net snippets collection
• Visual Basic .Net - How to check for the internet connection
• Visual Basic .Net - POP3 and Receiving E-mails
• Visual Basic .Net - Generate Random Combinations
• Visual Basic .Net - Play sounds on Button Click or Mouse Hover
• Visual Basic .Net - Progressbar control
• Visual Basic .Net Solution - The application failed to initialize
• Visual Basic .Net - Working with Database full example
• Visual Basic .Net - There is already an open DataReader associated
• Visual Basic .Net - SyBase Advantage Database [Add, Edit, Search, Delete and DataGridView]
• Visual Basic .Net - Math Functions  
• Visual Basic .Net - Communicating with clients [Requirements Docs, Use-Case]