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.
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.
Disclaimer: Dime-Co.Com is an online information article and video article network. All articles, video articles, comments, and other features herein are for informational purposes only and are provided "as is" without warranties, representations or guarantees of any kind. The views and opinions expressed in an article, comments, links or blogs are the author's own, and not necessarily those of dime-co.com's owners. For full disclaimer, please read our TOS.