Cannot open database with password
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.