Microsoft Knowledge Base Article
This article contents is Microsoft Copyrighted material.
©2005-©2007 Microsoft Corporation. All rights reserved.
Terms
of Use |
Trademarks
Article ID: 208222 - Last Review: July 15, 2004 - Revision: 1.1
ACC2000: "The Replication ID You Entered Is invalid" Error in Query
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.
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.
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.
Open the query in Design view and replace the braces with brackets.
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
- Open the sample database Northwind.mdb.
- Create a new query in Design view based on the Order Details table.
- Type {Order Details}.OrderID in the Field row of the query.
- Run the query or move to another field. Note that you receive the error message.
For more information about the use of brackets in expressions, click
Microsoft Access Help on the
Help menu, type
enter expressions in a design grid in the Office Assistant or the Answer Wizard, and then click
Search to view the topic.
For more information about globally unique identifers, click
Microsoft
Access Help on the
Help menu, type "replicate a database" in the Office Assistant or the Answer Wizard, and then click
Search to view "Changes made to your database when you use replication."
APPLIES TO
- Microsoft Access 2000 Standard Edition
Community Feedback System
Very often, it takes hours to solve a problem. Very often, you've looked high
and low, and have tried a lot of solutions. When you finally found it, chances
are, it was because someone else helped you. Here's your chance to give back.
Use our community feedback tool to let others know what worked for you and what
didn't.
Please also understand that the community feedback system is not warranted to be
correct, it's simply a system that we've built to let people try and help each
other. If something in a feedback response doesn't make sense to you, or you're
not comfortable making changes that the feedback talks about (like registry
edits), please consult a professional.
Thank you for using kbAlertz.com Feedback System.
-- Scott Cate