Record Is Deleted Error Message in MS Access

When you try to open a table, query, form, report or a data access page you may get the following error message:

“Record is deleted.”

In the case of a table or a query the error message displayed may be in the form:

“Msaccess can’t open the table in datasheet view.”

While if you are dealing with a report the error message may take the following form:

“Unable to carry out the command.

There was an error executing the command.”

This behavior is shown by the MS Access in the multi user environment when the database is stored on the network. When the LAN is spread in a building or a more wide area, then it is a common practice adopted by the users to save anAccess database on the network so that it can be accessed by them. These databases usually contain some important company or organization related information which can not be lost at any price. So it is required that no data loss may happen and the data will remain safe.

The above mentioned error messages occur if either the object or whole of the database is damaged. The problem arises when the same record in the database is being modified by two or more users simultaneously and in the mean time if any of the user forces the Access to close by shutting down his/her computer system.

To solve this problem Microsoft has suggested repairing the database using Compact and Repair utility tool. But there is a downslide to it that the database which has undergone a mild damage can be repaired by this tool but those which are highly damaged can’t be repaired using this tool, so at last your database may remain damaged or corrupted.

In this case the only option left to repair the database is to imply the Access Repair software. These software are read only software that without changing the original content of the database, are able to repair the database with much efficiency.

Stellar Phoenix Access Recovery software has marked a tremendous performance in repairing the Access databases irrespective of the amount of damage occurred to the database. The software is found to be compatible with all the file versions of MS Access including Access 2000, 2002, 2003 and 2007. If the databases contain a number of queries, forms, reports, or tables the software is able to repair all of them.

It possesses an advanced scanning feature in order to locate all the damaged files. The user needs not to be technically savvy to operate the software. So if you have any doubt about the performance of the software, the demo version is available to check out which of your mdb files are repairable.

Article Directory: http://www.article-tree.com

Celina D'Souza a student of Mass Communication doing research on data recovery software. He is also a freelancer for www.stellarinfo.com

Please Rate this Article

5 out of 54 out of 53 out of 52 out of 51 out of 5 

Not yet Rated