Microsoft KB Archive/310800

= ACC2000: You Receive &quot;Ambiguous Name Detected&quot; Error Message After You Replicate a Database =

Article ID: 310800

Article Last Modified on 6/25/2004

-

APPLIES TO


 * Microsoft Access 2000 Standard Edition

-



This article was previously published under Q310800



Moderate: Requires basic macro, coding, and interoperability skills.

This article applies to a Microsoft Access database (.mdb) and to a Microsoft Access project (.adp).



SYMPTOMS
After you use Replication Manager to replicate a database, you may receive the following error message if you perform certain actions, such as clicking a command button on a form, manually running code, or compiling the database:

The expression On Click you entered as the event property setting produced the following error: Ambiguous Name Detected:



CAUSE
This issue can occur if Replication Manager replicates a Microsoft Visual Basic for Applications procedure in the database.



RESOLUTION
To resolve this issue, delete the duplicate procedure. Follow these steps:
 * 1) Locate the procedure that the error message refers to, and then delete the duplicate procedure.
 * 2) While you are still in the Visual Basic environment, click Compile   on the Debug menu.



Steps to Reproduce the Issue

 * 1) Open the sample database, Northwind.mdb.
 * 2) Select the Customers table in the Database window, and on the Insert menu, click AutoForm to create a new form.
 * 3) In the new form, use the Form Wizard to add a command button that closes the form. When you are prompted to create a name for the command button, type cmdClose.
 * 4) Delete the command button from the form.
 * 5) Repeat step 3 to recreate the command button. Use the same name.
 * 6) Save and close the form.
 * 7) Open the form in Form view, and then click the command button.

Note that you receive the error message that is described in the Symptoms section.

Additional query words: prb

Keywords: kberrmsg kbprogramming kbprb KB310800

-

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

© Microsoft Corporation. All rights reserved.