Access workgroup connection setup

[williey]

I am trying to setup a connection to an Access database with workgroup security enabled.

The Jet OLEDB:System database field is defined with the security database info. Admin password is defined. The connection works the first time I tried it.

Since then, I have not got it to connect again. It keep failing on the "Test connection failed because of an error initializing provider. Cannot start your application. The workgroup information file is missing or opened exclusively by another user." error.

Of course the workgroup information file is there and in the same directory as the database file.

Anyone encountered the same issue before?

------------------------------------------
There are 10 kinds of people in this world. One that understands binary and the other one that does not.

 

[williey]

Finally fixed the problem after manually changing the connection string. The connection string generated by SSIS was causing the problem.

"Data Source=" + @[User::AccessPath] + "RegE_DATA.mdb;Provider=Microsoft.Jet.OLEDB.4.0;Persist Security Info=True;Jet OLEDB:System database=" + @[User::AccessPath] + "RegE.MDW;User ID=[userid];Password=[password];"

------------------------------------------
There are 10 kinds of people in this world. One that understands binary and the other one that does not.