I have been working with Perl Win32 GUI / MS-ACCESS for over 5 years
And have never come across this issue before until this week. The reason?
I have never had the situation where my Win32-GUI / Win32-ODBC front-end
To the MS-ACESS database was being used while an MS-ACCESS forms-based
User-interface was also being used by the company.
The native behavior of MS-ACCESS forms is to place null values in table columns
when a row is added and no value has been assigned to the column. My front-ends
always put BLANK values if the user has not entered a value (except for dates.
I place a null if the user does not set the date via the DateTime Win32-GUI control).