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


The information in this article applies to:

  • Microsoft Access for Windows 95 7.0
  • Microsoft Access 97
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."
Modification Type:MajorLast Reviewed:10/20/2003
Keywords:kberrmsg kbprb KB160753
©2003 Microsoft Corporation. All rights reserved.