Knowledge Base

ACC: Query Error "The Replication ID You Entered Is Invalid"

Article ID: 160753

Article Last Modified on 1/19/2007

APPLIES TO

This article was previously published under Q160753
Novice: Requires knowledge of the user interface on single-user computers.

SYMPTOMS

When you run 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 include 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. Note that you receive the error message.

REFERENCES

For more information about the use of brackets in an expression, search the Help Index for "[] (expressions)."

For more information about globally unique identifiers, search the Help Index for "GUIDs."

Keywords: kberrmsg kbprb KB160753


Send feedback to Microsoft

© Microsoft Corporation. All rights reserved.