Greetings to all.

I have a problem opening an access database which has password. The code goes like this..

  Set con = New ADODB.Connection
  con.Provider = "Microsoft.Jet.OLEDB.4.0"
  con.Open "test.mdb, "pwd"

where "pwd" is my password.

I get the following error..
"Cannot start your application. The workgroup information file is missing or opened by another user."

I thought I made a mistake by not giving the user name and hence I tried using
con.Open "test.mdb, "admin", "pwd"

But I still get the same error.

Don't know where I am going wrong.

Need help.

- Sai

it should be con.open "test.mdb", "admin", "pwd"
the double quotes are missing after you database name, that could be the problem, otherwise there shouldnt be any problem with that