Access Recovery to Fix MSysObjects Table Corruption

Published: 04th June 2010
Views: N/A

Microsoft Access System Objects have a number of tables, which have useful and significant information about your Master Database (MDB) file. One such database table is 'MSysObjects'. This table contains comprehensive information about various objects, including forms, reports, queries, triggers, stored procedures etc. Under some circumstances, this database table may get damaged. In such cases, the database objects can not be accessed or used. And thus, the database itself becomes completely inaccessible and you encounter data loss. In order to get your data back, access database recovery is essential.

All the objects of Microsoft Access database come in pretty handy when the Access database is first documented. In order to access the system objects, you need to set

'Views/Options/General/Show System' objects as 'yes'.
An extremely useful feature of MSysObjects table (that you should not ignore) is the critical information that is supplied by DateUpdate and DateCreate columns on Access Database objects.

You can use DateUpdate column in creation of the 'Last Update' query, which can tell you about the modules, reports, or forms that are modified within any specified period of time or since any particular date.

In case of corruption of MSysObjects table, you may not access the database objects. This behavior leads to database inaccessibility and data loss.

What causes MSysObjects table corruption?

MSysObjects is a hidden database table. You can not modify it directly. When you try to modify the Access database table using any alternate method, like by running a script or a query, the table may get damaged. When you try to manually modify this table, you might encounter the below error message:
"Record(s) cannot be read; no read permission on 'MSysObjects'."


In order to sort out MSysObjects table corruption, you need to restore the complete database from current backup. It replaces the damaged database table. However, if the backup is not available, access recovery is the only way to go.

You can easily repair and restore damaged MDB file using access recovery software. The applications use high-end scanning techniques to methodically scan entire database and extract all inaccessible data from it. They enable you to perform Do It Yourself access database recovery with simple graphical user interface.

Stellar Phoenix Access Recovery software repairs and restores damaged Access database after any kind of corruption. The software works well with Microsoft Access 2007, 2003, 2002 (XP), and 2000. It recovers all MDB file objects, such as tables, reports, forms, queries, views, and more.

Report this article Ask About This Article

More to Explore