RE: [Microsoft][ODBC Microsoft Access Driver] Syntax error in INSERT INTO statement.

Hi, i am new to access dbase. my problem is that i get the above error in the following code
objrs.addnew
objrs("username")=strusername
objrs("date")=date
objrs("time")=time
objrs.update

I have seen microsoft documentation that says this could be a bug, but on another page in my asp application, i have used this exact code sequence to update another table and this error did not occur.
please advice

__________________
Everything takes longer than you expect!

Hi, I made the following changes
objrs.addnew
objrs("username")=strusername
objrs("datein")=cstr(date)
objrs("timein")=cstr(time)
objrs.update
i also deleted my first db and created one with fields "username", "datein", and "timein" all text ("date" and "time" where of type date/time). It now works. my question therefore is why did the first one not work. furthermore, now that i have used string format instead of date/time in my db, can i still use sql to determine for example total time which requires summation of all times

You could have made just this change in the first case. formatted in either mm/dd/yyyy hh:mm:ss or yyyy-mm-dd hh:mm:ss

When you use those columns as TEXT types, you will have to do some patch work to do date/time calculations on those fields.

I would suggest to use date and time as single column and datatype as date/time. That should be the right way of approach for this.

Hope that helps.
Cheers!

_________________________
- Vijay G
Strive for Perfection

Hi,
Thanks for the help, i was begining to feel left out of the forum
:)