Hi,

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!!

Rgds,
Jennie.

Well, it eventually came to me in a flash of divine inspiration.

The field name 'Date' was causing the problem.

I currently owe the swear-box a fortune.

Hey Jennie,

If you don't want to change the field name, you can just use [Date] in your query rather than Date.

HTH,

Chris

Thanks Chris!

That's handy, now I don't have to change code elsewhere that selects that field.

Jennie.