Results 1 to 3 of 3
  1. #1
    Join Date
    May 2015
    Posts
    1

    Answered: Can't open mdb file

    I have a database in mdb format that will not open. When I try to open the file I get an error:
    "The Microsoft Access database engine stopped the process because you and another user are attempting to change data at the same time"

    I was the only user accessing the database and this occurred after a compact/repair.

    Any ideas on how to get the db working again?

  2. Best Answer
    Posted by loganwatts

    "The repair method attempts to recover only the tables, indexes and queries in the database. Do not attempt to repair damaged forms, reports, macros and modules. Before executing the Compact and Repair tool, please ensure the following condition:

    1. Do not open Access database must closed
    2. Sufficient storage space available - minimum double in size of your Access database on that Disk.
    3. Close the .mdb file related to .ldb file before you delete the .ldb file.
    4. Then Run the Compact and Repair tool

    See if this helps:
    http://itknowledgeexchange.techtarge...pc-to-network/
    http://www.filerepairforum.com/forum...-2007-database
    http://www.mdb.openfiletool.com/ MDB Open File Tool"


  3. #2
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    495
    Provided Answers: 24
    1. because the ms db can be fragile, always backup, and do it often
    2. This error USUALLY means , the db is on the network and someone else is in the db.
    3. SOMETIMES its a false error, because the db crashed and the .LDB file is still there. Delete the .ldb file THEN open the db.

  4. #3
    Join Date
    May 2015
    Posts
    1
    Provided Answers: 1
    The repair method attempts to recover only the tables, indexes and queries in the database. Do not attempt to repair damaged forms, reports, macros and modules. Before executing the Compact and Repair tool, please ensure the following condition:

    1. Do not open Access database must closed
    2. Sufficient storage space available - minimum double in size of your Access database on that Disk.
    3. Close the .mdb file related to .ldb file before you delete the .ldb file.
    4. Then Run the Compact and Repair tool

    See if this helps:
    http://itknowledgeexchange.techtarge...pc-to-network/
    http://www.filerepairforum.com/forum...-2007-database
    http://www.mdb.openfiletool.com/ MDB Open File Tool

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •