I don't see anything wrong with the statement. I would check on the view definition the type that has been mapped to this field.
Just for testing, create a new remote view with the key field and this datetime field only and do not set any mappings, just mark the field as updatable and check the "send updates" box.
If you are setting the properties for the view programmatically post the code and maybe we can spot what the problem is.
>Flores,
>
>Following way, I update the remote table -
>
>
>Update vueTable Set TimeStamp = DateTime()
>
>
>
>
The error message is :>
>
>Connectivity Error : [Microsoft][ODBC Microsoft Access Driver]
>Syntax error in UPDATE stateme
>
>
>
>The error only in timestamp field which type is datetime. I have tried other datetime fields, they update without showing any error.