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

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

[John]

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

<D> schreef in bericht news:Oy*************@tk2msftngp13.phx.gbl...

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

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

[Bob Barrows [MVP]]

D wrote:

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
--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"