In regard to guarding against NULL values which bomb your program, how do you then send a date data type into an MSACCESS table from VFP when the field it is coming from is a DATE data type but it's going into a DATETIME data type. And, the date field is empty. This bombs when trying to insert it into an ACCESS table, coming out as an unacceptable NULL value.

I do not know a lot about Access data types, but are you aure that Access is complaining about null datetimes? It seems to me that ir would be more like to complain about empty dtaetimes in much the same way that SQL server doesn't have empty datetimes and you need to send null instead.

You can probabaly find this information in the Access on-line help.