ACC97: "Name Conflicts..." Error When Opening Replica
ID: Q172162
|
The information in this article applies to:
SYMPTOMS
Advanced: Requires expert coding, interoperability, and multiuser skills.
When you try to open a replica, you may receive the following error message
Name conflicts with existing module, project or object library.
and you are unable to open the replica.
CAUSE
A conflict is preventing Microsoft Access from compiling and saving the
replica's Visual Basic for Applications project.
The first time you open a replica following synchronization, Microsoft
Access automatically compiles and saves the replica's Visual Basic for
Applications project. In the Design Master, you cleared the Replicable
property on a module's property sheet, and then synchronized with the
replica. However, an error prevented Microsoft Access from updating the
replica's project. So, although the module no longer appeared in the
replica, it had not been removed from the project. You then opened the
Design Master, made the module replicable again, and synchronized with the
replica. You receive the error because Microsoft Access is attempting to
update the project again; however, it is now attempting to add a module to
the project that is already there.
RESOLUTION
Open the Design Master and make the modules unreplicable. After
synchronization, you can open the replica. If you want the modules to be
transferred to the replica during synchronization, rename them.
STATUS
Microsoft has confirmed this to be a problem in Microsoft Access 97. This
problem no longer occurs in Microsoft Access 97 Service Release 1.
NOTE: Stand-alone Microsoft Access 97 Service Release 1 is not currently
available, but you can update your copy of Microsoft Access 97 to Service
Release 1 by downloading Microsoft Office Service Release 1 from
Microsoft's Web site at:
http://officeupdate.microsoft.com/Articles/sr1fact.htm
MORE INFORMATION
Steps to Reproduce Problem
- Start Microsoft Access and open a new blank database.
- Open a new blank module and type the following procedure:
Function test1()
Msgbox "test"
End Function
Close the module and save it as Module1.
- Open a new blank module and type the following procedure:
Function test2()
Msgbox "test"
End Function
Close the module and save it as Module2.
- On the Tools menu, point to Replication, and click Create Replica. When
prompted to close the database, click Yes. When prompted to make a
backup, click No.
- In the Location Of New Replica dialog box, note the location and file
name of the new replica. Click OK.
- Click OK when prompted to reopen the database, which is now the Design
Master.
- Close the Design Master and open the replica. Note that Module1 and
Module2 appear when you click the Modules tab. Close the replica.
- Open the Design Master.
- Right-click Module1 and click Properties; clear the Replicable check
box.
- Right-click Module2 and click Properties; clear the Replicable check
box.
- Synchronize with the replica, and then close the Design Master.
- Open the replica. When you receive the "Automation error" message,
click OK. Note that when you click the Modules tab, the two modules do
not appear on the list.
- Close the replica.
- Open the Design Master.
- Right-click Module1 and click Properties. Click to select the
Replicable check box, and then click OK.
- Synchronize with the replica, and then close the Design Master.
- Open the replica. Click OK when you receive the "Automation error"
message.
- Click Yes when you receive the message:
'Module1' has been changed since the last time you opened it, either
by another user or because another instance of it was opened on your
own machine. Do you want to replace the changes that you or another
user made?
- Notice that Module1 appears when you click the Modules tab. Close the
replica.
- Open the Design Master.
- Right-click Module1 and click Properties. Click to select the
Replicable check box, and then click OK.
- Synchronize with the replica, and close the Design Master.
- Open the replica. Note that you receive the error
Name conflicts with existing module, project or object library.
REFERENCES
For more information about problems with projects in replicas, please see
the following article in the Microsoft Knowledge Base:
Q171207 Removing Replicated Module Causes Automation Error
Keywords : kberrmsg MdlProb RplGen
Version : WINDOWS:97
Platform : WINDOWS
Issue type : kbbug