Error: workgroup information file missing???

G

Guest

I am trying to access an Access2002 database table using OleDb Data Provider.
I am getting an error message saying "Workgroup information file is missing
or opened exclusively by another user". I believe it could not find .mdw
although I did create one.

Could someone tell me how I can fix this problem? Thanks
 
G

Guest

I have worked it out. Just in case someone’s interested.

"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\temp\test.mdb;Jet
OLEDB:System database=c:\temp\SYSTEM.MDW;User ID=abc;Password=xyz"
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Database connection error 3
workgroup information file is missing 1
Workgroup 97 4
workgroup information is missing 4
Workgroup file information file error: OleDB to Access file 3
"The workgroup information file is missing or opened exclusively by another user" ARRRRGH! 1
Workgroup Information File 5
How do I update a ODBC query in Excel using pivotTables in VBA? 6

Top