Labview 2012 (64bit) not working with ActiveX and MSAccess

[DSMarcinko]

I have a program developed to open a MSAccess database file and import data using ActiveX commands. The program works with LabView 2012 (32bit) but fails on the ActiveX open command when using LabView 2012 (64bit). I also have the application built as an EXE and it works fine in a windows 32 bit environment (XP or Win 7-32bit) but fails when run on Win 7-64bit. I isolated the error down to the Active X automation Open VI.

Anyone have a solution for the incompatibility?

summary

1.) VI and EXE works on XP and Win 7-32bit

2.) EXE fail on Win 7-64bit.

3.) VI works on Win 7-64 bit with LV 2012 (32bit)

4.) VI fails on Win 7-64 bit with LV 2012 (64bit)

[Dennis_Knutson]

It looks like you are trying to load a 32-bit DLL from a 64-bit OS. Do you have a 64-bit version of access installed? You'll need to change to that. On the other hand, ActiveX with Access is so slow. You can speed things up considerably by using ADO (i.e. NI's Database Connectivity Toolkit or something like LabSQL).