Quantcast

Jump to content

» «
Photo

.mdb file

2 replies to this topic
evanmckinney
  • evanmckinney

    Player Hater

  • New Members
  • Joined: 18 Dec 2015
  • United-States

#1

Posted 18 December 2015 - 07:17 PM

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?


Ed 
  • Ed 

    Puusnofl

  • Andolini Mafia Family
  • Joined: 14 May 2005
  • None
  • GTA Series Awards - Best Contribution 2009.
    Excellent GTAForums Contributor (carried over from misc. awards).

#2

Posted 18 December 2015 - 11:05 PM

Is there a .ldb file with the same name in the same directory? If I remember the extension correctly, it's the lock file for Access DBs. Basically, it doesn't let anyone else use the file. I think (read: am not 100% sure) you're safe to delete the .ldb file and carry on with whatever you were doing.

husainparsa
  • husainparsa

    Player Hater

  • New Members
  • Joined: 20 Dec 2015
  • Qatar

#3

Posted 20 December 2015 - 11:39 AM Edited by husainparsa, 20 December 2015 - 11:39 AM.

Short guide can be helpful for you, if not see helpful topics are collected over Internet, if again they can't help you, then your corruption is complicated and needs to solve via more powerful solution https://www.openfile...om/mdbopen.html MDB Open File Tool

 

• Launch the Microsoft Access application, but do not try to open the corrupted MDB file.

• Go to "Tools" in the top menu bar, expand the "Database Utilities" submenu and select the "Compact and Repair Database" option if you are using Access 2002 or 2003. If you are using Access 2007 or 2010, you can find the "Compact and Repair Database" option by clicking the Microsoft Office button and going to the "Manage" menu.

• Highlight the MDB file that you want to restore and click the "Compact" button.

• Enter a name for a new database file, which will contain the restored data from the damaged MDB file.

• Navigate to the location on your hard drive where you want to save the restored version of the file.

• Click the "Save" button. Access will now compact and repair the MDB file and save a restored version in the location you selected.





1 user(s) are reading this topic

0 members, 1 guests, 0 anonymous users