You are here: DIME Home > Software Reviews > Resolving “Record is deleted” Access error

Resolving “Record is deleted” Access error

Sometimes it so happens that you are unable to open a table, query, form, or a report in the Access database. This might be due to Access corruption. You can resolve this using a professional and efficient repair Access tool.

Author: Carney Bud
Date: Nov 22, 2011 - 5:43:55 AM

Printer friendly page

Let’s consider a real life scenario wherein when you try to open a table, query, form, or a report in the Access 2000 database, which is stored on a network drive, you get to face the following error message:

“Record is deleted.”

Just in case the object is a table or query, you get to face another error message which is as follows:

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

However, if the object is a report, you get to face the below mentioned error message:

"Unable to carry out the command."

Or

“There was an error executing the command.”

Now that we have come to know the error messages, let’s figure out the actual cause behind the occurrence of the above mentioned error messages.

The root cause behind the occurrence of the above mentioned error message is corruption in Access database files.
Now that we have come to know the error message, let’s quickly figure out as to what is the resolution for the aforementioned issue.

The resolution for the above mentioned issue is as follows:

First and foremost way out is that you can use a last, valid, and proper Access file backup to restore your valuable data.

However, just in case you do not have a proper and valid Access file backup with you then we would suggest you to use the Compact and Repair to repair the Access database files.

In order to repair Access database files using the Compact and Repair, you need to perform the following steps:

1.Click Tools - Database Utilities - Compact and Repair Database.
2.In the Database to Compact From dialog box, find and then click the database which is generating the error messages.
3.Click the Compact button.
4.In the Compact Database Into dialog box, select the location for the new file, type a new name for the file.
5.Click the Save button.

By performing the aforementioned steps, you should be able to repair the damaged and corrupt Access database files; however, there is one loop hole if using this method which is as follows:

The compact and repair utility is able to repair the damaged and corrupt Access database files only in case of minor corruption. Just in case the Access database is highly damaged or severely corrupt, you need to use a professional as well as efficient third party Access repair tool to repair the damaged and corrupt Access database files.

A number of repair Access tools are available in the market. Carefully choose the one that is as per your requirements.

However, in case you feel confused, we would suggest you to use the free trial version of the tool to understand the basic functionality of the Access repair tool.

Kernel for Access is a professional as well as proficient third party tool that is specifically devised to repair the damaged and corrupt Access database files and that too in an easy and efficient manner.

Kernel for Access comes with an intuitive, interactive, as well as absolutely easy to understand graphical user interface which enables both novice as well as professional users to easily work on the tool.

The author of this article is a content writer with immense knowledge on Access corruption as well as repair access database 2007 issues. He uses his knowledge to write useful articles on how to Repair Access files.

View all articles by Carney Bud

Link to this article:

Follow & Share Your Favorite Video Articles

Tell a Friend About This Site

Tweet about this site

Follow @dimeco

Recommended Associates

Do you write?

Would you like submit your articles and have them approved on a priority status? Find out more about how you can become a Priority author for pennies a day! Click here.