Greetings to all.

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

  Set g_data.con = New ADODB.Connection
  g_data.con.Provider = "Microsoft.Jet.OLEDB.4.0"
  g_data.con.Open "Data\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
g_data.con.Open "Data\test.mdb, "admin", "pwd"

But I still get the same error.

Don't know where I am going wrong.

Need help.

- Sai