I am trying to update Access DB records and get this error message
Microsoft JET Database Engine (0x80040E14)
Syntax error in UPDATE statement.

Since the code works when I use only two text fields and one interger field, but not when I add other fields, I think the problem is in my SQL. Here is what the code is generating

UPDATE ServiceRecords SET client = 'High Roller', tech = 'Gruen', serviceda = #8/25/2003#, hours = 2, followupda = #1/1/1111#, morehours = 0, completed = #1/1/1111#, status = 'No', parts = 'List the parts here.', action = 'Tell what you did here to make notes for next time.' WHERE (ID = 10)

I have changed everything I can think to change that might in any way conflict (hours2 to morehours, etc.) I'm sure it is something simple but I just can't find it.

I figured it out myself. I took out all the SQL generating code and replaced it one line at a time. It didn't like the field named action - comments works.