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.
Vlad Grynchyshyn, Project Manager, MCP
vgryn@yahoo.comICQ #10709245
The professional level of programmer could be determined by level of stupidity of his/her bugs
It is not appropriate to say that question is "foolish". There could be only foolish answers. Everybody passed period of time when knows nothing about something.