Rob,

Your problem may relate to empty dates. Access understand NULL dates, but not empty dates. You may need to write a little function that will scan the fields of your view looking for dates and replacing them with NULL if they're empty. Run it before you try to send updates from the view.

>Using VFP 6.0 to create an updatable view to an Access .mdb backend. I need to return several fields for update. Everything gets updated except if there is a date field populated. I get a SQL Insert Into error for the date. Numerics and character fields have no problem. The table I'm updating is related to another in the Access container so I relate it in the view but don't use any of the fields in the related table. I think the view is set up appropriately. Need Help!
>
>Thanks.