Contrainst clause syntax error (1 Viewer)

[CHICHI]

I've done my research but I don't think anyone has given a simple solution.

CREATE TABLE Manufacturers
(
ManufacturerID INTEGER CONSTRAINT ManfID PRIMARY KEY,
ToyID Integer NOT NULL,
CompanyName CHAR (50) NOT NULL,
Address CHAR (50) NOT NULL,
City CHAR (20) NOT NULL,
State CHAR (2) NOT NULL,
Postalcode CHAR (5) NOT NULL,
Areacode CHAR (3) NOT NULL,
PhoneNumber CHAR (8) NOT NULL UNIQUE,
CONSTRAINT ToyFk FOREIGN KEY (ToyID) REFERENCES Toys (ToyID)
ON UPDATE CASCADE
ON DELETE CASCADE
);

The the code can be run after the two cascades were deleted.

This was taken from a book yet ACCESS told me there was a syntax error in CONSTRAINT Clause.

What should be revised about "ON UPDATE CASCADE" and "ON DELETE CASCADE"?

Many Thanks!

 

[ByteMyzer]

You will need to set the SQL Server Compatible Syntax (ANSI 92) option in your database before your SQL statement will work as written. See the following link for the steps on how to do this:

http://www.access-programmers.co.uk/forums/showpost.php?p=860156&postcount=11

 

[CHICHI]

It worked!!!

Thank you ByteMyzer!