I was getting an error in the INSERT INTO and thought it was related to the #. I corrected that, thanks to you, but still got the error.
Then I enclosed action as [action] and the error has disappeared! But action as a reserved word is not listed here: http://support.microsoft.com/?id=248738
However, I am still getting an error when I try to add a new record:
Microsoft VBScript runtime error '800a01c2'
Wrong number of arguments or invalid property assignment: 'Replace'
/display_recordsTEST1.asp, line 163
The server doesn't like this:
my_dispatched = Replace( Request.Form("dispatched") )
This field originally was:
my_dispatched = CDATE( Request.Form("dispatched") )
but the field in the MDB is now a text field so I changed the CDATE to Replace - but it doesn't seem to like it.