Trying to update a date field
I'm trying to use the UPDATE statement to update a date field in an Access database, but no matter what I do it doesn't work. :(
Here's the code :
Set objRS2 = Server.CreateObject("ADODB.Recordset")
strSQL2 = "UPDATE tblSubject SET Date = #4-Nov-2004# WHERE Subject = '" & strSubject & "'"
objRS2.Open strSQL2, strConnect
I just keep getting an error 'Syntax error in UPDATE Statement'. I've done searches online for how to update date fields, and have tried everything I've found, but no luck.
I can successfully update the Subject field, btw - it's just when I try to update the date that I run into problems.
Please help save what's left of my tattered sanity!!