Microsoft Access conection

[mcnedrow]

Hello;

I am working with mocrosoft access to save my data from the LabVIEW test.

From my development PC all is well, I can read Write and delete data from Access as I would expect.

when I build the .exe and move it to the lab, the VI gets hung up on a connection error.  with a path that is not on the lab PC or my developemnt pc.

The long and short of the erroe message is there is a problem with my connection string.  That string is more or less right out of the LabVIEW example. "Provider=Microsoft.ACE.OLEDB.12.0;Persist Security Info=False;Data Source=%s\\"

The rest of the string is the access database name.

The error is an ADO error

ADODB.Connection:provider can not be found

The lab PC does not have Access or LabView installed...............

Any help is appreaciated.

Do I need access on the target PC?  Or is there something I did incorrectly when I built the .exe?

Thanks

[jcarmody · Accepted solution]

You don't need Access installed and I can't tell if you've done anything wrong, but I've faced the same problem and solved it by installing the Microsoft Access Database Engine 2010 Redistributable from - http://www.microsoft.com/en-us/download/details.aspx?id=13255

[mcnedrow]

THANK YOU.....

That did the trick......working like a charm now.