database connection error

[J_McHenry]

I am using the database connection VI's to write new information to Microsoft access database on my network. Once i updated to 2017, i started to get the ADO Error: 0x800A0E7A (see attachment for full error details). I read several other posts saying that the bitness of LabView and the database need to be the same and i checked this and both LabView and the access are running 32bit. I cannot find any other solutions online that make any sense to me. Any troubleshooting help is greatly appreciated. 

[Mark_Yedinak]

Is your ODBC driver also 32  bit?

[rolfk]

To expand on Mark’s question when you start up the ODBC Manager on a 64-bit Windows system you really start up the 64-bit version of it unless you explicitly browse to C:\Windows\SysWOW64 and start Odcbad32.exe in there to configure ODCB DSNs that can be used from 32-bit processes.

https://support.microsoft.com/en-ph/help/942976/odbc-administrator-tool-displays-both-the-32-bit-and...