Hi!

In the view designer setup view to use only key value in SQL Where clause. When view is updated, UPDATE-SQL command is generated. To identify record, WHERE part of that command should contain key value and ,aybe other values. In VFP for view there are 3 options for that - include all fields, include modified fields and use only the key field. When datetime field is included, VFP probably formats it incorrectly for MS Access, that is why you get that error.

HTH.

>When I update my remote view to underlying data (Ms Access), it prompt me Connectivity error : [microsoft][ODBC ms access driver] data type mismatch i criteria expression.
>
>The Ms Access data type is datetime and my vfp data type is datatime too.
>
>What is the problem?
>
>TIA.