pwinters
Programmer
- Sep 12, 2002
- 34
I have a website form where a user will enter various data that will update an Access database through the mssql code in my page. I am receiving an error : "Syntax error in INSERT INTO statement", which is related to the 2 Date/Time fields I have in the form.
My guess is that the problem is due to Access wanting to update both the Date & Time(MM/DD/YYYY HH:MM:SS), but I only need a Time (HH:MM:SS) inserted in these fields.
Is there a way to format these fields in the Insert Into SQL Statement that would prevent this error and allow the user to update the database with their data?
Thanks
My guess is that the problem is due to Access wanting to update both the Date & Time(MM/DD/YYYY HH:MM:SS), but I only need a Time (HH:MM:SS) inserted in these fields.
Is there a way to format these fields in the Insert Into SQL Statement that would prevent this error and allow the user to update the database with their data?
Thanks
