>I am using a REMOTE VIEW through an ODBC connection.
Unfortunately I have no big experience with remote views.
You map a DateTime field to Date one in the view, right?
I thing that it is a VFP job to conver it back to datetime when you send back to ACCESS.
Not sure about EMPTY DateTime fields in ACCESS also, but maybe in ACCESS that field is not NULLable and when you send back a NULL in that field you got errors. What happens if you put: DATE(1900,1,1) in your RV instead of empty date or NULL?
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.