error opening database

  • Thread starter Scott_Brasted via AccessMonster.com
  • Start date
S

Scott_Brasted via AccessMonster.com

Greetings,

I recently had to change computers so I backed up my data, changed machines,
reloaded Access 2K, applied the million or so updates, reloaded the files and
tried to open a database. I keep getting the error:

"The Microsoft Jet Database cannot open the file " ... ". It is already
opened exclusively by another user, or need permissions to view its data."

This happens with some databases and with others. One in particular causes a
very large problem for me. Does anyone have a remedy for this? I really need
this data.

Best,
Scott
 
J

Jeff Boyce

Scott

Use Window Explorer and look in the folder where the Access .mdb file lives.
Is there also an .ldb file with the same name?

If so, (and only after backing up your .mdb!!!!!), try deleting that .ldb
file. Access creates a "locking database" (ldb) to keep track of who has
the db open. Maybe it got confused...

Good luck!

Regards

Jeff Boyce
Microsoft Access MVP

--
Disclaimer: This author may have received products and services mentioned
in this post. Mention and/or description of a product or service herein
does not constitute endorsement thereof.

Any code or pseudocode included in this post is offered "as is", with no
guarantee as to suitability.

You can thank the FTC of the USA for making this disclaimer
possible/necessary.
 
S

Scott_Brasted via AccessMonster.com

That was it, thanks a million. I love learning new things.

Best,
Scott

Jeff said:
Scott

Use Window Explorer and look in the folder where the Access .mdb file lives.
Is there also an .ldb file with the same name?

If so, (and only after backing up your .mdb!!!!!), try deleting that .ldb
file. Access creates a "locking database" (ldb) to keep track of who has
the db open. Maybe it got confused...

Good luck!

Regards

Jeff Boyce
Microsoft Access MVP
Greetings,
[quoted text clipped - 15 lines]
Best,
Scott
 
J

Jeff Boyce

You are welcome.

Jeff

Scott_Brasted via AccessMonster.com said:
That was it, thanks a million. I love learning new things.

Best,
Scott

Jeff said:
Scott

Use Window Explorer and look in the folder where the Access .mdb file
lives.
Is there also an .ldb file with the same name?

If so, (and only after backing up your .mdb!!!!!), try deleting that .ldb
file. Access creates a "locking database" (ldb) to keep track of who has
the db open. Maybe it got confused...

Good luck!

Regards

Jeff Boyce
Microsoft Access MVP
Greetings,
[quoted text clipped - 15 lines]
Best,
Scott
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top