error opening database

Discussion in 'Access Configuration' started by Scott_Brasted via, Apr 28, 2010.

  1. 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.

    Scott_Brasted via, Apr 28, 2010
    1. Advertisements

  2. Scott_Brasted via

    Jeff Boyce Guest


    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!


    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
    Jeff Boyce, May 4, 2010
    1. Advertisements

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


    Scott_Brasted via, May 4, 2010
  4. Scott_Brasted via

    Jeff Boyce Guest

    You are welcome.


    Jeff Boyce, May 4, 2010
    1. Advertisements

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 (here). After that, you can post your question and our members will help you out.