Get secured Access Data

• Sylvain Coutu

  Ten Centuries

  Points: 1077

  More actions

  June 14, 2006 at 2:47 pm

  #190951

  Hi All,

  I don't have an extensive knowledge of Access and I have to query an .mdb that has been secured with a password on Admin account.

  I have tried using OPENROWSET, OPENDATABASE and a LinkedServer with all the same outcome. The error message is has follow:

  Server: Msg 7399, Level 16, State 1, Line 1

  OLE DB provider 'Microsoft.Jet.OLEDB.4.0' reported an error. Authentication failed.

  [OLE/DB provider returned message: Cannot start your application. The workgroup information file is missing or opened exclusively by another user.]

  OLE DB error trace [OLE/DB Provider 'Microsoft.Jet.OLEDB.4.0' IDBInitialize::Initialize returned 0x80040e4d:  Authentication failed.].

  I have read a few article on workgroup information file and got lost. I have tried creating a .mdw and set the registry with no luck.

  I am able to connect to the .mdb if I remove the password. But in my production environment it is out of the question.

  Any idea will be welcome.

  Thanks

• Yelena Varshal

  SSC-Dedicated

  Points: 34286

  More actions

  June 14, 2006 at 3:00 pm

  #643804

  I usually get a good help for MS ACCESS on the website http://www.accessmonster.com

  They have forums like us here where you can ask questions or just search the forums. I got a couple of good solutions from there.

  Regards,Yelena Varsha