Hi All,
Sorry I am new to databases but I've spent the day trying to get LabVIEW 2014 to connect to a Microsoft Access 2013 Database. I've tried a .mdb and .accdb but neither work. I tried to make a udl but it was 64 bit and wouldnt load, I tried the fix on various forums (https://forums.ni.com/t5/LabVIEW/Creating-and-Editing-udl-files-in-64-bit-Windows/td-p/1526358) but get the error "Provider cannot be found. Ensure that the provider has been installed properly."
I have the 64 bit driver for Microsoft Access Engine installed as I'm running 64-bit office.
I tried installing LV2014 64 bit but there isn't database connectivity in it.
Doing this: http://kb.vmware.com/selfservice/microsites/search.do?language=en_US&cmd=displayKC&externalId=101040...
Allowed me to get a 32-bit DSN added but I continue to get error -2146824582 in labview.
The example within labview called "Database Connection.vi" works but the "Connect to ACCDB Database.vi" does not.
Any help would be appreciated. I've attached the database in question (I've had a few messages saying invalid format when trying fixes but it always opens in access, I dont really want to have to type it out again) and a couple of screenshots.