Hi,

I try to connect to a password secured database from VB but there is a problem. This is the code which I have:

pconInters.ConnectionString = _
"Persist Security Info=False;" & _
"User ID=" & strUser & ";" & "Password=" & strPassword & ";" & _
"Data Source=" & App.Path & "\Database.mdb"
pconInters.Open

Everytime when I run the code I get an error mesage: "Connection failed because of an error in initializing provider. Can't start your application. The workgroup information file is missing or opened exclusively by another user.". But the workgroup config file is in the System dir.


Before that this is what I did in Access: First I opened the database exclusively by selecting the exclusive checkbox. Then I went to Tools->Security->User and Group Accounts and I clicked on New. Then I typed a name and a personal ID. I guess that was the user name and PID for my self. I clicked Ok and Ok again. Then I went to: Tools->Security->Set Database Password and I typed my password. Then I tried to connect to the database from VB using the username and password which I just selected and I ended up nowhere as decsribed above.

Regards:
VBJ