ni.com is currently undergoing scheduled maintenance.

Some services may be unavailable at this time. Please contact us for help or try again later.

LabVIEW

cancel
Showing results for 
Search instead for 
Did you mean: 

open .mdb database

The problem is that you are using LabVIEW 32-bit but the ODBC Administrator that you start from your Control Panel is the 64-bit variant since you are running 64-bit Windows. Instead you want to start the 32-bit version of the ODBC Administrator in C:\Windows\SysWOW64\odbcad32.exe. This version will enumerate the 32-bit ODBC drivers and there you have a JET DB driver. You can then setup a DSN in there that you can use from the Database VIs when running LabVIEW 32-bit. 

 

 

Rolf Kalbermatter  My Blog
DEMO, Electronic and Mechanical Support department, room 36.LB00.390
0 Kudos
Message 11 of 13
(994 Views)

I found that the ACE drivers are better than the JET drivers.

The connections string is also a bit tricky.

image.png

The above connection string:

Provider=Microsoft.ACE.OLEDB.12.0;Persist Security Info=False;Data Source="%s"

 

---------------------------------------------
Former Certified LabVIEW Developer (CLD)
Message 12 of 13
(977 Views)

Thank you so much for your help! Now it works!

0 Kudos
Message 13 of 13
(964 Views)