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

• Microsoft Access 2000

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.

REFERENCES

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."

Additional query words: prb

Keywords : kberrmsg kbdta QryParm QryProb
Version : WINDOWS:2000
Platform : WINDOWS
Issue type : kbprb