Microsoft KB Archive/295200

= You receive a &quot;Cannot Update. Database or Object Is Read-Only&quot; error when you convert an uncompiled, read-only database in Access 2002 =

Article ID: 295200

Article Last Modified on 8/11/2004

-

APPLIES TO


 * Microsoft Access 2002 Standard Edition

-



This article was previously published under Q295200



Novice: Requires knowledge of the user interface on single-user computers.

This article applies only to a Microsoft Access database (.mdb).



SYMPTOMS
When you try to convert an uncompiled, read-only database to Microsoft Access 2002, you may receive the following error message:

Cannot update. Database or object is read-only.

When you try to quit Access after you receive this error message, you may also receive the following error message:

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



RESOLUTION
To work around this problem, follow these steps:  Open Access, but do not open the database that you want to convert. On the Tools menu, point to Database Utilities, point to Convert Database, and then click To Access 2002 File Format. Select your database, and then click Convert. Give your database a unique name, and then click Save. Click OK when the following dialog box appears:

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.

For more information about conversion, click Help.



<div class="status_section">

STATUS
Microsoft has confirmed that this is a problem in Access.

<div class="moreinformation_section">

Steps to Reproduce the Behavior
 In Access 2000, create a new blank database.</li>  Create a new module, and then add the following code: Function Test MsgBox &quot;Test&quot; End Function </li> Save the module as Module1.</li> Quit Access 2000.</li> In Windows Explorer, right-click the database that you created in step 1, and then click Properties.</li> In the Properties box, click to select the Read-only check box, click Apply, and then OK.</li> Open the database in Access 2002.</li> On the Tools menu, point to Database Utilities, point to Convert Database, and then click To Access 2002 File Format.</li> Give your database a unique name, and then click Save.

Note that you receive the error message that is mentioned in the &quot;Symptoms&quot; section of this article.</li></ol>

Additional query words: pra

Keywords: kberrmsg kbdatabase kbprb kbpending KB295200

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.