Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2003
    Location
    UK
    Posts
    122

    Unanswered: Syntax error in CONSTRAINT clause

    Create Table [MyHome](ID AUTOINCREMENT CONSTRAINT pk1 PRIMARY KEY, UserID Integer, ModuleID Integer CONSTRAINT F_KEY REFERENCES module, SortVal Integer, Pos Integer,) ;

    Gives me this:


    Microsoft JET Database Engine
    error '80040e14'Syntax error in CONSTRAINT clause.

    I have tried

    Create Table [MyHome](ID AUTOINCREMENT CONSTRAINT pk1 PRIMARY KEY, UserID Integer, ModuleID Integer CONSTRAINT F_KEY REFERENCES module (ID), SortVal Integer, Pos Integer,) ;

    no joy there either.

    I'm useing an Access 2k DB via ASP in case that makes blind bit of difference.
    Matt the Hat says: "what!?"
    A child of five could understand this! Fetch me a child of five!
    SCARY HARD CHALLENGE: http://www.dbforums.com/showthread.php?threadid=988682

  2. #2
    Join Date
    Sep 2003
    Location
    UK
    Posts
    122
    opps there seems to be a bonus comma!!!
    Matt the Hat says: "what!?"
    A child of five could understand this! Fetch me a child of five!
    SCARY HARD CHALLENGE: http://www.dbforums.com/showthread.php?threadid=988682

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •