Results 1 to 2 of 2
  1. #1
    Join Date
    May 2004

    Unanswered: Insert syntax error

    I'm not quite sure if this is the right forum. I am trying to execute a insert statement. Using an ADO connection with Jet 4 (MS Access and VBA).

    "INSERT INTO tblLocking (Table, Record, User) VALUES ('tblDiscrepancy','70','mnewheiser')"

    I am getting a syntax error on the above statement. All fields that i am inserting to (Table, Record and User) are all text types, and the table does exist.

    There is a fourth column in the table (LockID) which is a Access [Auto-Number] type(why i'm not sure on the forum) do i need to declare this in the statement.

    Any help would be much appreciated as its is beginning to drive me mad.


  2. #2
    Join Date
    May 2004
    Ok, so it appears the solutions wasn't as complicated as i thought it would be.

    Although 'Table' and 'User' where valid columns in the table, they are also reserved words (or something like that). So in the statement they needs [ and ] around them (i.e. [Table])

    Don't have to slit my wrists now.

Posting Permissions

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