Access 2016 ADO SQL - INSERT a 'null' date value
Posted on 2016-09-24
I have some Data/Time fields in a table in Access, where I have set it to Required = No.
When I fire off an INSERT (via ADO) to insert data it doesn't like it if there is no Date. ie. Blank.
In my solution there will be 'blanks' in these Date columns. I want to INSERT a blank.
Has somebody got any ideas on how to work around this please?
(I'd like to try and avoid having a dummy date like 01/01/1900 to represent blanks)