View Full Version : can't append records in append qeury


tkgb606
09-24-2001, 08:06 AM
error message says

greek life set (0) fields to null due to a type conversion failure, and it dident add (0)records to the table do to key violations, (0) records due to lock violations ,(1) record due to validation rule violations.
do you want to run the action query anyway?


the only thing that i have done is edit validation rule on one control and have changed it back to the orignal and it still gives error

Pat Hartman
09-24-2001, 04:01 PM
Unless you have coded your own validation rules, the one that is probably causing the trouble is the AllowZeroLengthStrings property. The default is no but if your data may contain empty strings, you will need to change the property to yes.