CopyPastehas never been so tasty!

How to fix 'Record is deleted' error in MS Access

by jenymaria

  • 1
  • 0
  • 0

Microsoft Access, which comes bundled with Microsoft Office suite of Applications, is a pseudo-relational database management system. The database creates either an .accdb or .mdb file. These files are prone to corruption in many scenarios including application malfunction, virus infection, operating system malfunction, and others. Also, when the database files are used in a multi-user environment, they have higher chances of becoming corrupt. An abrupt shutdown by a user can affect the records or tables. In such scenarios, you must look for the clean and updated backup copy of the database. However, if no backup is available, you must use the inbuilt compact and repair utility to repair the damaged Access database. If nothing seems working, then look for a third-party Access recovery software.

Consider a scenario, wherein, you try to open a table, query, form or report in a Access 2000 database (which is used in a multi-user environment), stored on a network or server, you may receive the following error:

"Record is deleted."

If the object is a table or query, you may receive another error message which goes like:

"Msaccess can't open the table in datasheet view."

And, if the object is a report, then you will also get the following error messages:

"Unable to carry out the command."


"There was an error executing the command."


The above errors surface when either an object or database is damaged. Damage can occur, for example, if two users try to modify the same record in a table simultaneously, and one user quits MS Access by abruptly shutting down the system.


To overcome the problem, you can undertake the following Access database recovery  steps:

Compact and repair database
1.In Access 2000, go to Tools menu, point to Database utilities, and then click Compact and Repair Database
2.In the Database to Compact Form dialog box, locate and then click the database which is generating the error messages, and then click Compact.
3.In the Compact Database Into dialog box, select an appropriate folder location for the new file, type a unique name for the file in the File name box, and then click Save.

The above method can work fine if there are minor damages in database, but in case of severe damages, you must consider opting for a professional Access repair utility. Such tools can recover damaged databases without modifying the original data.

Add A Comment: