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

• Microsoft Access versions 7.0, 97

SYMPTOMS

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

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.

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

1. Create a new, blank database.



2. On the Tools Menu, point to Replication, and then click Create Replica.



3. Click Yes when prompted to close the current database.



4. Click No when prompted to create a backup of the database.



5. 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.



6. On the File menu, click Open Database.



7. 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.

Keywords : kberrmsg RplGen
Version : 7.0 97
Platform : WINDOWS
Issue type : kbbug