Syntax Error

Results 1 to 3 of 3

Thread: Syntax Error

  1. #1
    Matt1999 Guest

    Default Syntax Error

    I am trying to add a "Date" Field to my Access database that will keep track of when a user first registers with my site. I added the Date field in the Database and I am now trying to send the Date to the database as soon as a user registers, but I am having trouble. I put in some bogus values and Response.Write the Cm.Execute and this is what I get:<BR><BR>Insert into tUsers (UserName, UserPassword, Email, Date) values (&#039;UserId&#039;,&#039;Password&#039;,&#039;Ema il&#039;,&#039;Date&#039;) <BR><BR>Microsoft OLE DB Provider for ODBC Drivers error &#039;80040e14&#039; <BR><BR>[Microsoft][ODBC Microsoft Access Driver] Syntax error in INSERT INTO statement. <BR><BR>/Matt1999/test/newusertest.asp, line 31 <BR><BR><BR>I don&#039;t see the syntax error. Am I missing something? It worked until I put the Date field in this Insert statement.<BR><BR>Thanks!

  2. #2
    Join Date
    Dec 1969

    Default Date is a reserved word in Access....

    Put it into brackets.... [Date]

  3. #3
    Matt1999 Guest

    Default RE: Date is a reserved word in Access....

    That must have been it!! Thanks!

Posting Permissions

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