ACC2000: CREATE CONSTRAINT Clause Help Example Missing a Parenthesis (237852)

The information in this article applies to:

Microsoft Access 2000

This article was previously published under Q237852

Moderate: Requires basic macro, coding, and interoperability skills.

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

SYMPTOMS

In the "CONSTRAINT Clause (Microsoft Jet SQL)" topic of the Microsoft Access Help system, the example in the fourth bulleted item in the "Remarks" section is incorrect. The example, which reads as follows, is missing a parenthesis at the end:

   CREATE TABLE Orders (OrderId INTEGER PRIMARY KEY, CustId INTEGER, 
   OrderNotes NCHAR VARYING (255), CONSTRAINT FKOrdersCustId FOREIGN KEY 
   (CustId) REFERENCES Customers ON UPDATE CASCADE ON DELETE CASCADE

RESOLUTION

Add a closing parenthesis to the end of the example, as follows:

   CREATE TABLE Orders (OrderId INTEGER PRIMARY KEY, CustId INTEGER, 
   OrderNotes NCHAR VARYING (255), CONSTRAINT FKOrdersCustId FOREIGN KEY 
   (CustId) REFERENCES Customers ON UPDATE CASCADE ON DELETE CASCADE)

REFERENCES

For more information about the Constraint clause, click Microsoft Access Help on the Help menu, type constraint clause (microsoft jet sql) in the Office Assistant or the Answer Wizard, and then click Search to view the topic.

Modification Type:	Minor	Last Reviewed:	7/15/2004
Keywords:	kbbug kbdocerr kbnofix KB237852