Microsoft KB Archive/208222

= ACC2000: "The Replication ID You Entered Is invalid" Error in Query =

Article ID: 208222

Article Last Modified on 7/15/2004

-

APPLIES TO


 * Microsoft Access 2000 Standard Edition

-



This article was previously published under Q208222



This article applies only to a Microsoft Access database (.mdb).

Novice: Requires knowledge of the user interface on single-user computers.



SYMPTOMS
When you run a query or add a field to a query in an unreplicated database, you may receive the following error message:

The Replication ID you entered is invalid.



CAUSE
You used braces ({}) instead of brackets ([]) around an object name in your query.

NOTE: This error message also occurs if you use braces instead of parentheses around the arguments of a function or procedure.



RESOLUTION
Open the query in Design view and replace the braces with brackets.



MORE INFORMATION
Brackets are often placed around the name of a table, field, form, or parameter when you create a query in Design view. If you use braces instead of brackets, Microsoft Access tries to interpret the text between the braces as a globally unique identifier (GUID). Microsoft Access uses GUIDs in replicated databases. If the text inside braces is not a valid GUID, an error occurs.

Steps to Reproduce Behavior

 * 1) Open the sample database Northwind.mdb.
 * 2) Create a new query in Design view based on the Order Details table.
 * 3) Type {Order Details}.OrderID in the Field row of the query.
 * 4) Run the query or move to another field. Note that you receive the error message.

