ACC2000: You Receive "Ambiguous Name Detected" Error Message After You Replicate a Database (310800)


The information in this article applies to:

  • Microsoft Access 2000
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: ProcedureName

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 Database on the Debug menu.

MORE INFORMATION

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.
Modification Type:MajorLast Reviewed:6/25/2004
Keywords:kberrmsg kbprb kbProgramming KB310800
©2004 Microsoft Corporation. All rights reserved.