Microsoft KB Archive/172162

= ACC97: "Name Conflicts..." Error When Opening Replica =

Article ID: 172162

Article Last Modified on 1/20/2007

-

APPLIES TO


 * Microsoft Access 97 Standard Edition

-



This article was previously published under Q172162



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



SYMPTOMS
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://office.microsoft.com/en-us/assistance/HA010449921033.aspx



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.</li> Click OK when prompted to reopen the database, which is now the Design Master.</li> Close the Design Master and open the replica. Note that Module1 and Module2 appear when you click the Modules tab. Close the replica.</li> Open the Design Master.</li> Right-click Module1 and click Properties; clear the Replicable check box.</li> Right-click Module2 and click Properties; clear the Replicable check box.</li> Synchronize with the replica, and then close the Design Master.</li> 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.</li> Close the replica.</li> Open the Design Master.</li> Right-click Module1 and click Properties. Click to select the Replicable check box, and then click OK.</li> Synchronize with the replica, and then close the Design Master.</li> Open the replica. Click OK when you receive the "Automation error" message.</li>  Click Yes when you receive the message:

<pre class="fixed_text">      '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? </li> Notice that Module1 appears when you click the Modules tab. Close the replica.</li> Open the Design Master.</li> <li>Right-click Module1 and click Properties. Click to select the Replicable check box, and then click OK.</li> <li>Synchronize with the replica, and close the Design Master.</li> <li>Open the replica. Note that you receive the error

Name conflicts with existing module, project or object library.</li></ol>

<div class="references_section">