I have a database in mdb format that will not open. When I try to open the file I get an error

[JoLang86]

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?

[masterupc]

Through what are you opening the db? Access or another application?

Before opening it check for a ***.ldb file. Delete it if found.

Good luck!

[mincemeat]

Alternatively, create a new blank MDB database and then import everything from the broken one.

This is my last-resort approach since MDB's tend to corrupt themselves during compact/repair, depending on which version of Access you are using.

If the corrupted MDB has a password then you will obviously need to supply that during the copy.

It's been a while since I last did this so I cannot remember exactly where or how you do the importing but it isn't a difficult task.

Remember, IMPORT, don't LINK the data.

Good luck!

[paulboyd83]

1) Compact and Repair the MDB, as follows:

Hold down the Shift key and open the MDB, then from the menu >>Tools>>Database Utilities>>Compact and Repair ...

Close the mdb after the Compact & Repair.

2) Execute the Decompile (See example syntax below) >> after which, your database will reopen.

3) Close the mdb

4) Open the mdb and do a Compact and Repair (#1 above).

5) Close the mdb.

6) Open the mdb:

a) Right click over a 'blank' area of the database window (container) and select Visual Basic Editor. A new window will open with the title 'Microsoft Visual Basic' ... followed by then name of your MDB.

b) From the VBA Editor Menu at the top of the window:

>>Debug>>Compile

Note ... after the word Compile ...you will see the name of your 'Project' - just an fyi.

Useful links:

https://social.msdn.microsoft.com/Forums/en-US/a6875337-1cd0-459a-b1b0-4747e55bdb76/corrupt-msmmmobmdb-file?forum=Offtopic

Recovery Toolbox for Access - https://access.recoverytoolbox.com/