access db connection error *update*

[joshuajmurray]

So I'm using Access 03' and have a connection problem. I get this error:

"-2147217843

DB Tools Open Connec (String).vi->openDB.vi<ERR>Exception occured in Microsoft JET Database Engine: Cannot start your application. The workgroup information file is missing or opened exclusively by another user. in DB Tools Open Connec (String).vi->openDB.vi"

This is my connection info:

Provider=Microsoft.Jet.OLEDB.4.0;
Data Source=C:\Code\Labview\SubVIs\Test Stand\DRF_Results.mdb;

I tried this too:

Provider=Microsoft.Jet.OLEDB.4.0;
Data Source=C:\Code\Labview\SubVIs\Test Stand\DRF_Results.mdb;
User Id=test;

Password=test;

And this:

Provider=Microsoft.Jet.OLEDB.4.0;

SystemDB=C:\Code\Labview\SubVIs\Test Stand\db_info.mdw
Data Source=C:\Code\Labview\SubVIs\Test Stand\DRF_Results.mdb;

User Id=test;

Password=test;

I also have test user name and password wired to the associated terminals on the the DB Tools Open Connection.vi

If I don't use security the db works fine but IT guys want the db secured so I need to figure this out..

I also tried just using a  Database Password that wasn't user specific (no User ID in the connection file) but have the same problem.

Thanks guys!!

[joshuajmurray]

So I think I found a solution. It uses the db security rather than workgroup security:

I don't need high security or different access levels so this works fine for me. 

Connection info:

Provider=Microsoft.Jet.OLEDB.4.0;
Data Source=C:\Code\Labview\SubVIs\Test Stand\DRF_Results.mdb;
Jet OLEDB:Database Password=1234;

The pertinent text is highlighted.