DerekMcDonald
Technical User
Hi. I'm trying to append records from an imported table to an existing table in Access 97, but I'm getting the "validation rule violation" error message. If I change the "allow zero-length strings" property to "yes" for the fields to which I'm appending, I don't get the error message and the append is successful.
As the properties on the imported table are set to the same default properties as the "appendee" table, Access must be reading imported null values as zero-length strings. This could be a rather large pain in the tush when doing regular imports/appends...
Anyone know why Access behaves this way? Is there a solution?
Thanks!!! [sig][/sig]
As the properties on the imported table are set to the same default properties as the "appendee" table, Access must be reading imported null values as zero-length strings. This could be a rather large pain in the tush when doing regular imports/appends...
Anyone know why Access behaves this way? Is there a solution?
Thanks!!! [sig][/sig]