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).
