Wednesday, September 9, 2009

"Cannot Update. Database or Object Is Read-Only" error when you convert an uncompiled, read-only database in Access 2002

Database is an important part of every business organization. It's used to store and manage information in organized way. MS Access is easily available, effective, and commonly used database that comes with Microsoft Office package. A database file can get corrupted when the storage space of database maximizes, Exit the application improperly, Improper System Shutdown, troubleshoot network hardware, virus infection and so on which increases the chance of database corruption. For getting rid from this type of data loss you must have a data backup. In case, if you don’t have backup then you have to repair access file.

Sometime when you try to convert an uncompiled, read-only database to MS Access 2002, you may encounter/face the following error message:

“Cannot update. Database or object is read-only.”

When you try to quit Microsoft Access after receive the above error message, you may also receive the below error message:

“Microsoft Access has encountered a problem and needs to close. We are sorry for the inconvenience.”

This error message occurs when one of the given conditions is true:

The file name (xyz) is surrounded with quotation marks, for example "C:\xyz.xls".
A carriage return feed is at the end of the file name in the FileName property.

To work around this problem, follow the given steps:

1.Open MS Access, but do not open your database.
2.On the Tools menu, click on Database Utilities, then point to Convert Database, and then click to Microsoft Access 2002 File Format.
3.Select your database, and then click Convert.
4.Give your database a unique name, and then click Save.
5.If you may receive the below message then click OK

After you have converted this file to Access 2002 File Format, the new file cannot be shared with Access 2000 users or Access 97 users. In case if you still get the error message then your database file is corrupted. You need to repair your corrupt access database using advance access repair application. If you follow the precaution, you will never suffer with database corruption.

No comments:

Post a Comment