Re: How to update my access to current date??

From: John (y_at_spam.com)
Date: 10/02/04 

Date: Sat, 02 Oct 2004 07:35:52 GMT

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

<D> schreef in bericht news:OyLw6GFqEHA.644@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!

Relevant Pages

  • Re: How to update my access to current date??
    ... I try using the following sql statement.. ... > Syntax error in UPDATE statement. ... This email account is my spam trap so I ...
    (microsoft.public.inetserver.asp.general)
  • How to update my access to current date??
    ... I try using the following sql statement.. ... Syntax error in UPDATE statement. ... resolve this problem?? ...
    (microsoft.public.inetserver.asp.general)
  • SQL Update problem
    ... The following SQL statement is resulting in the error after it: ... JET Database Engine Description: Syntax error in UPDATE statement. ...
    (microsoft.public.inetserver.asp.db)
  • Re: Syntax error in FROM clause
    ... It appears that the maximum length of the SQL statement has been reached. ... "George wilson" wrote in message ... >><MS ACCESS MVP> ... >>> a "Syntax error in FROM clause" and is unable to view ...
    (microsoft.public.access.forms)
  • Re: INSERT command doesnt work in Access
    ... that OleDbException, that says "Syntax error in SQL statement". ... Lately I've tried simple OleDbCommand, ...
    (microsoft.public.dotnet.framework.adonet)