How to update my access to current date??

[D]

Hi, got a problem here. I try using the following sql statement..

strSQL = "UPDATE Messages(TABLE) SET Date=now() where MessageID=25"

The error given to me:
Syntax error in UPDATE statement.

I'm doing an update of the date already stored in my Access. How do i
resolve this problem?? Thanks

cheers

 

[John]

If Date is a field, name it myDate instead of Date (reserved word)

 

[Bob Barrows [MVP]]

Hi, got a problem here. I try using the following sql statement..

strSQL = "UPDATE Messages(TABLE) SET Date=now() where MessageID=25"

The error given to me:
Syntax error in UPDATE statement.

I'm doing an update of the date already stored in my Access. How do i
resolve this problem?? Thanks

John is correct. You used a reserved keyword for a column name (Date). This
should be avoided, but if you cannot change the column name, you can work
around it by surrounding the column name with brackets [] when you use it in
your sql statements executed via ADO:

... SET [Date]=now() ...

For more words to avoid in your databases, see here:
http://www.aspfaq.com/show.asp?id=2080

Bob Barrows