Access DB password issues

[cpopham]

I have a database and if I do not set the password, my connection works fine. When I add a database password, I get an error message "Cannot start your application. The workgroup information file is missing or opened exclusively by another user."

 

Here is my connection string:

       strCN = "Provider=Microsoft.Jet.OLEDB.4.0;" & _
                   "Data Source='" & strDBPath & "';" & _
                   "User ID=Admin;" & _
                   "Password=" & strDBPW

 

Now if I take password off of the database and remove the & strDBPW from my connection string it works fine. Any ideas?

 

Thanks, Chester

[Afraits]

Is the password a database level password? If so your connection string is slightly wrong, instead of the UserID & password your need to use Jet OLEDB:Database Password

 

ie

strCN = "Provider=Microsoft.Jet.OLEDB.4.0;" & _
                   "Data Source='" & strDBPath & "';" & _
                   "Jet OLEDB:Database Password=" & strDBPW

[cpopham]

That was it. I have not dealt with password protected Access databases until now. Thanks for the help, Chester