The below errored happened when I tried to add a new record to my database with the add feature in ASPRunner. When I went to add the new record, I could add data in everyfield but the startdate and starttime fields.
I formatted the date and time fields with short date and time in asprunner. After the error, I went into my MSAcces database changed my datatype for these to fields as text and then I was able to enter data in asprunner but I still didn't get the date and time formatt. What am I missing. Please help me.
ASP error happened
Technical information
Error number -2147217913
Error description [Microsoft][ODBC Microsoft Access Driver] Data type mismatch in criteria expression.
URL /tblevents_edit.asp
SQL query insert into [tblevents] (Eventnotification, StartDate, StartTime, [Tech Staff], EventType, EventDescription, Notes) values ('ddddd', '', '', 'ddd', 'ddd', 'dddd', 'dddd')