-
Trying to set a Visual FoxPro Date field to Null via DAO/ODBC results in an error.
The FoxPro ODBC driver does not use Null for an empty date. You can set the date field to 12/30/1899 instead. The Visual FoxPro ODBC driver translates this value into an empty date.
The question is what do you do with Microsoft Access? I am stuck!!!!
-
In the design mode in Access if you use Date/Time as the Data Type you can set the "Required" property to no. When you add records do not put a value in the Date field and it will treat it as a Null value.
Hope this helps.
