It is amazing what a good night's sleep can do for the brain ...!!! The error was caused by the field name [user]. I guess this must be a keyword in the Jet Engine. Once I changed the field to [fldUser] the ASP code worked. Not sure why, when I removed the field and data from the ASP code, it still failed...but now that it works, there is nothing to fix. Thanks for your help, Bob. regards Paul
----- Original Message ----- From: "Paul Robinson" <[EMAIL PROTECTED]> To: <[email protected]> Sent: Wednesday, April 13, 2005 11:20 AM Subject: Re: [AspClassicAnyQuestionIsOk] Syntax error in INSERT INTO statement > > Bob, > I have tried your suggestion. It has no effect. ASP code fails but SQL > string works in Access > regards > Paul > > ----- Original Message ----- > From: "BobFilipiak" <[EMAIL PROTECTED]> > To: <[email protected]> > Sent: Tuesday, April 12, 2005 9:07 PM > Subject: Re: [AspClassicAnyQuestionIsOk] Syntax error in INSERT INTO > statement > > > > > > Try putting the memo field last.. > > > > > > Bob Filipiak > > A question not asked > > is a lost opportunity to learn. > > ----- Original Message ----- > > From: "Paul Robinson" <[EMAIL PROTECTED]> > > To: <[email protected]> > > Sent: Tuesday, April 12, 2005 3:16 PM > > Subject: Re: [AspClassicAnyQuestionIsOk] Syntax error in INSERT INTO > > statement > > > > > > > > > > Bob, > > > The SQL string that I detail at the start of my post is generated by a > > > Response.write strSQL statement > > > And it is that same SQL that I tested in Access QBE and it worked > > > > > > Paul > > > > > > ----- Original Message ----- > > > From: "BobFilipiak" <[EMAIL PROTECTED]> > > > To: <[email protected]> > > > Sent: Tuesday, April 12, 2005 8:01 PM > > > Subject: Re: [AspClassicAnyQuestionIsOk] Syntax error in INSERT INTO > > > statement > > > > > > > > >> > > >> Try commenting out your objConnExecute(strSQL) and add this in it > place: > > >> > > >> response.write("[" & strSQL & "]") > > >> > > >> this will display what is actually being used. > > >> > > >> > > >> Bob Filipiak > > >> A question not asked > > >> is a lost opportunity to learn. > > >> ----- Original Message ----- > > >> From: "Paul Robinson" <[EMAIL PROTECTED]> > > >> To: <[email protected]> > > >> Sent: Tuesday, April 12, 2005 1:22 PM > > >> Subject: [AspClassicAnyQuestionIsOk] Syntax error in INSERT INTO > > >> statement > > >> > > >> > > >> > > > >> > Can anyone spot the obvious that I am missing? > > >> > > > >> > I am trying to append data into an Access database and I keep getting > > > the > > >> > error message 'Syntax error in INSERT INTO statement' > > >> > I have worked through the SQL, one item at a time removing each and > > > trying > > >> > to find the offending item. However, I keep getting the error > message. > > >> > Yet, when I copy the SQL straight over to Acces and paste it into a > > > query, > > >> > it works. > > >> > I am assuming then, that the Jet engine is objecting to something, > > > though > > >> > for the life of me, after a hard day's work, I cannot see what. > > >> > The full SQL is > > >> > > > >> > INSERT INTO tblCADreSchedule(autoCadFk, oldDate, oldTime, newDate, > > >> > newTime, fldComments, user,datWhen) VALUES > (1323,#8-Apr-2005#,#15:00#, > > >> > #12-Apr-2005#,#18:00#,'were ','robinsop',#12-Apr-2005#) > > >> > > > >> > autoCadFk is a number field > > >> > oldDate, oldTime, newDate, newTime, datWhen are date/time fields > > >> > fldComments is a memo field > > >> > user is a text field > > >> > > > >> > My ASP code is : > > >> > > > >> > strConnect = "Provider=Microsoft.Jet.OLEDB.4.0; Data > > >> > Source=d:\Projects.mdb;" > > >> > > > >> > Set objConn = server.CreateObject("ADODB.Connection") > > >> > objConn.open strConnect > > >> > > > >> > strSQL = "INSERT INTO tblCADreSchedule(autoCadFk, " & _ > > >> > > > >> > "oldDate, > > > " > > >> > & _ > > >> > > > >> > "oldTime, > > > " > > >> > & _ > > >> > > > >> > "newDate, > > > " > > >> > & _ > > >> > > > >> > "newTime, > > > " > > >> > & _ > > >> > > > >> > "fldComments, " & _ > > >> > "user, > " > > > & > > >> > _ > > >> > > > > "datWhen)" > > >> > & _ > > >> > " VALUES (" & iCadReq > & > > >> > ",#" & _ > > >> > > > >> > FormatLoadDate(datReqDate,3) & "#,#" & _ > > >> > > > >> > FormatDateTime(datReqTime,4) & "#, #" & _ > > >> > > > >> > Request.Form("RequestReplyDate") & "#,#" & _ > > >> > > > >> > Request.form("cboTime") & "#,'" & _ > > >> > > > >> > Request.Form("txtComments") & "','" & _ > > >> > > strUser > > >> > & > > >> > "',#" & _ datToday & "#)" > > >> > > > >> > objConn.Execute (strSQL) > > >> > > > >> > > > >> > > > >> > [Non-text portions of this message have been removed] > > >> > > > >> > > > >> > > > >> > > > >> > Yahoo! Groups Links > > >> > > > >> > > > >> > > > >> > > > >> > > > >> > > > >> > > > >> > > > >> > > > >> > > >> > > >> > > >> > > >> > > >> Yahoo! Groups Links > > >> > > >> > > >> > > >> > > >> > > >> > > >> > > > > > > > > > > > > > > > Yahoo! Groups Links > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > Yahoo! Groups Links > > > > > > > > > > > > > > > > > > > Yahoo! Groups Links > > > > > > > Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/AspClassicAnyQuestionIsOk/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
