Access Db w/ pw to excel

[timely2]

I am able to get code work if a user and password are defined on the access db.

pw = ty
ud = "Admin"
' Path to Transfers.mdb
MyConn = "d:\personal\tely\pickeraccuracy.mdb"
Set cnn = New ADODB.Connection
With cnn
.Provider = "Microsoft.Jet.OLEDB.4.0"
.Open MyConn, ud, pw
End With
Set rst = New ADODB.Recordset
rst.CursorLocation = adUseServer

But I can not get it to work if a password is used for everything and not difined to a specific usergroup. When I try to use the same code as above I get:

"Cannot start your application. The workgroup information file is missing or opened exclusively by another user."

both access and excel are the same version of the suite.

Any ideas?

Thanks
Tim

 

[PHV]

You may try this kind of connection string:
"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=d:\personal\tely\pickeraccuracy.mdb;Jet OLEDB:System Database=\path\to\file.mdw;"

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886