11 MS Access

In order to communicate with a MS Access database file (from LabVIEW), an ODBC or OLEDB provider is needed.

Access Database Engine

The Access Database Engine provides several components that can be used to facilitate data transfer between Microsoft Office system files and other applications, even if they are not Microsoft Office applications.

Downloads

Microsoft Access Database Engine 2016 Redistributable

Select the 32 bit version for 32 bit LabVIEW applications and - accordingly - the 64 bit version if you're working in LabVIEW 64 bit!

If the current (2016) version does not work because of alleged incompatibilities between Office and the database file, you can try installing older versions (2010).

Providers

The name of the provider that comes with the ADE 2016 is Microsoft.ACE.OLEDB.16.0.

Example of a connection string:

  Provider=Microsoft.ACE.OLEDB.16.0;Persist Security Info=False;Data Source=C:\path\to\db.mdb