A report is one of the major objects of Microsoft Access. It is used to organize or summarize information for viewing and printing purposes. In a detail report, you can include summary data such as totals, counts, percentages etc, whereas, a summary report doesn't include selected records but instead summarizes the data and displays total counts, percentages and other summary data. However, if you try and open a damaged report in Access database, you might experience various error messages. Additionally, Access might exit abruptly, leading to further problems like database corruption. In such situations, it is a wise step to use the backup copy of the affected database. And, in case you do not have an updated backup copy, you must get assistance from a third-party Access repair software.
Consider a situation, wherein, you have an Access 2000 database, which is used in a multi-user environment. When you try to open a report in the database stored on a network, you might not be able to do so. Also, you might encounter the following error message:
"Record is deleted."
In case of object being a report, you might also get the following error messages:
"Unable to carry out the command."
"There was an error executing the command."
The error messages can erupt in the following conditions:
•If the object in question is damaged. In this particular case, it is the report which could have got damaged.
•Or if the Access database is itself corrupt or damaged
In a multi-user environment, damage can occur in many instances. One of the typical cases is when two users try to modify the same record in a table, and one of them quits Access database in an abrupt manner.
In order to fix errors caused by damage, you must consider the following Access database repair steps:
•Use Compact and Repair
1.Go to Tools>Database Utilities, and click Compact and Repair database
2.Find and click the problematic database in the Database to Compact from dialog box
4.In the Compact Database Into dialog box, choose a suitable folder location for the new database file, type a new name in the File Name box, and click Save.
•If corruption is severe and the above method fails to give good enough results, then download and employ a professional Access repair application.
For repairing and restoring Access databases efficiently, you must get your hands on Stellar Phoenix Access recovery. The application repairs corrupt Access databases created with MS Access 2007, 2003, 2002 and 2000 versions and recovers tables, queries, reports, macros etc. This Access database repair software lists all repairable database components in a tree-view format.
'Unable to carry out the command' error