Error -2146824582: Open Connection VI Broken for Access 2016 Database

Updated May 3, 2018

Reported In

Software

  • LabVIEW Professional
  • LabVIEW 2016 Database Connectivity Toolkit
  • LabVIEW Base
  • LabVIEW Full
  • LabVIEW 2015 Database Connectivity Toolkit

Other

Secondary Software: Microsoft Access 2016

Issue Details

When I try to use the Open Connection VI from the Database Connectivity Toolkit to connect to my Microsoft Access database, I receive the following error.

Error -2146824582: Provider cannot be found.

How can I solve this issue?

Solution

This error is generated due to a driver compatibility issue. To solve this, you can either change your database to an older version of Microsoft Access, install a previous version of the Microsoft Access Database Engine, or install an older Microsoft Office system driver.

If you are able to use a .mdb file instead of a .accdb file, save your database as 2002-2003 version. Complete the following steps to change to an older version of Microsoft Access:
 

  1. Open your Microsoft Access database.
  2. Navigate to Save As.
  3. Under Save Database As, select Access 2002-2003 Database.
  4. Update your VI to reflect the path change.


If you want to continue using the .accdb database format, you will have to uninstall the 2016 Microsoft Access Database Engine and install the 2010 engine. Complete the following steps to change to an older version of Microsoft Access Database Engine:
 

  1. Navigate to Control Panel»Uninstall a Program. Search for the Microsoft Access database engine. If you don't have an engine installed yet, skip to step 3.
  2. Uninstall Microsoft Access database engine 2016 (English).
  3. Download the version of Microsoft 2010 Runtime consistent with the bitness of your LabVIEW. For example, if you have LabVIEW 32-bit, you will download the 32-bit Runtime. Downloading the wrong driver for your bitness of LabVIEW will generate the same error.
  4. Restart your machine.


If you received this error after upgrading Microsoft Office from 2010 to 2016, installing the 2007 Office System Driver: Data Connectivity Components will reassociate the driver in your system.

Additional Information

If you receive Error -2147467259 after exhausting the above solutions, follow the steps in Creating a Microsoft Data Link file (UDL) for Connecting to a Database in LabVIEW.

WAS THIS ARTICLE HELPFUL?

Not Helpful