I tested this with a field named timestamp and worked OK, could the problem be something else?
Check the array values from AError() to see if it gives you more info. If you have total control over this MDB, would it be too much trouble to change the name? Being a reserved word it is bound to give you problems down the road.
>Thanks.
>
>I have tried the way you mentioned but problem is still there when updating :
>
>
>Update VUEHV_MASTER set timestamp = datetime()
>
>
>I have also A97.