Microsoft KB Archive/171208

= ACC: "Can't Update..." Error Opening Replica Read-Only =

Article ID: 171208

Article Last Modified on 1/20/2007

-

APPLIES TO


 * Microsoft Access 95 Standard Edition
 * Microsoft Access 97 Standard Edition

-



This article was previously published under Q171208



Advanced: Requires expert coding, interoperability, and multiuser skills.



SYMPTOMS
When you open a database replica in Microsoft Access 7.0 or 97, you may receive the following error message:

Can't Update. Database or object is read-only.

This may be followed by the following error message, depending on your version of Microsoft Access.

In Microsoft Access 97
Microsoft Access couldn't create storage space for a Visual Basic module.

  -or-

Automation error.

Catastrophic failure.

In Microsoft Access 7.0
OLE Automation Error



CAUSE
You are trying to open the replica read-only immediately after it was created or synchronized with another replica.



RESOLUTION
When you open a replica for the first time after its creation or synchronization with another replica, open it for read/write access. This will ensure that Microsoft Access is able to compile and store the Visual Basic for Applications project in the replica. The next time you open the replica, you will be able to open it for read-only access.



STATUS
Microsoft has confirmed this to be a problem in Microsoft Access 7.0 and 97.



MORE INFORMATION
The first time you open a replica after its creation, or after synchronization with another replica whose Visual Basic for Applications project has changed, Microsoft Access will attempt to compile and store the replica's Visual Basic for Applications project. The compiled Visual Basic for Applications project is stored in an internal system table.

When you open a replica for the first time after its creation or synchronization with another replica, Microsoft Access cannot store the compiled Visual Basic for Applications project in the replica if you are opening it read-only. This results in the error(s) listed in the "Symptoms" section.

Steps to Reproduce Behavior
 Create a new, blank database. On the Tools Menu, point to Replication, and then click Create Replica. Click Yes when prompted to close the current database. Click No when prompted to create a backup of the database.</li> Select a location for the new replica, and then click OK. You will receive a confirmation message indicating the database has been converted to a Design Master, and that a replica has been created. Click OK to close the message.</li> On the File menu, click Open Database.</li> Locate the replica you created in step 5, right-click it to view its shortcut menu, and then click Open Read-Only. Note that you receive the error message:

Can't Update. Database or object is read-only.

</li></ol>

Additional query words: can t update database or object is read only

Keywords: kbbug kberrmsg KB171208

-

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

© Microsoft Corporation. All rights reserved.