SQL Access Query

1,185 pts.
Tags:
Access Datasheet
Access query
Microsoft Access
SQL
SQL Access
SQL Query
I am using the book SQL for Microsoft Access. and the below statement is from the book and for some reasone I am getting a sytex error on the  word "Udate"

    Why would that be?

 CREATE TABLE Manufacture ( ManufactureID 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), Postalcode CHAR (5) NOT NULL, Areacode CHAR (3), Phonenumber CHAR (8) NOT NULL UNIQUE, CONSTRAINT ToyFK FOREIGN KEY (ToyID) REFERENCES Toy (ToyID) ON UPDATE CASCADE ON DELETE CASCADE );



Software/Hardware used:
MS2000, AS400, Access 2000
ASKED: February 16, 2010  11:00 AM
UPDATED: February 16, 2010  6:22 PM

Answer Wiki

Thanks. We'll let you know when a new response is added.

I spelled the work update incorrectly in the question but in the statement it is spelled correctly.

Discuss This Question: 4  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • CompEng
    it is eary! The word is word not work.
    1,185 pointsBadges:
    report
  • carlosdl
    Hi CompEng. You asked this question a couple of weeks ago. Here's the link to your first question: SQL for MS Access Syntax issue Is there something you want to add to the discussion ?
    65,110 pointsBadges:
    report
  • CompEng
    So does that mean that I need to use the Visual Basic or the Module side of the Access? If that were so would I just copy the answer into the module screen?
    1,185 pointsBadges:
    report
  • carlosdl
    Yes, just copy the suggested code, and press the 'run' button.
    65,110 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following