Results 1 to 2 of 2
  1. #1
    frankvfox is offline Novice
    Windows 7 64bit Access 2003
    Join Date
    Sep 2008
    Location
    Hendersonville, Tennessee
    Posts
    6

    Unhappy Syntax Error In Insert Into Statement

    Table: Fields
    Fields: FieldID Autonumber
    TableID Number
    ProjectID Number
    FieldName Text (50)
    DataTypeID Number
    DataLength Number
    Query:


    insert into fields (tableid, projectid, fieldname, datatypeid, datalength) values (1, 1, 'Table #1 Field #1', 1, 50)

    What's wrong with this? I'm stumped.

  2. #2
    frankvfox is offline Novice
    Windows 7 64bit Access 2003
    Join Date
    Sep 2008
    Location
    Hendersonville, Tennessee
    Posts
    6

    Arrow Insert Into Error

    There's not a lot of activity on this forum. Nobody has offered a solution. Meantime I've discovered you cannot use the field name TableID for a foreign key. It's okay for a primary key. Use it as a foreign key and Access will throw up.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Hide zero value in report and date syntax
    By Alex Motilal in forum Access
    Replies: 0
    Last Post: 11-16-2008, 09:11 AM
  2. Updating two tables using SQL Insert Into
    By glazzaro in forum Programming
    Replies: 0
    Last Post: 05-02-2008, 10:52 PM
  3. Insert Dash between set of Numbers
    By Jhankish in forum Programming
    Replies: 2
    Last Post: 04-19-2007, 08:02 AM
  4. IF Statement with Minutes
    By sal_gxer in forum Queries
    Replies: 0
    Last Post: 02-12-2007, 08:39 AM
  5. multiple iif statement NEED HELP PLZ
    By scott munkirs in forum Reports
    Replies: 1
    Last Post: 09-27-2006, 05:21 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums - Senior Forums