Good Morning

Does anybody have any thoughts about why this error occurs.

"cannot start application workgroup information file missing or opened
exclusively by another user"

I'm using ADO to open a Backend db (Access 97 just has a password). I can
open via explorer with password.

If there is no password set the code below works (without id & password).
both 97 & 2k



   Dim cnn As ADODB.Connection

  'Set the provider name
  Set cnn = New ADODB.Connection
  cnn.Provider = "Microsoft.Jet.OLEDB.4.0"


 'Open a connection to the data
  cnn.Open "D:\POa\HrLa\SourceCode\HrLa_Data.mdb", "admin", "flubber"

One last fact PC has both access 97 & 2000 on it (and works well).
For test purposes.
I have tried all the permutations e.g 3.51, 97 2000 vba vb6 and always get
the same error (it always works without a password there are no other
users).

Best Regards