access 97 append query fails due to validation rule violations - there are no validation rules in either source table or target table

[MLH]

Why would that happen?

[Trevor Best]

MLH wrote:

Why would that happen?

Try .Execute method, it may give a more meaningful error message.

--
[Oo=w=oO]

[Allen Browne]

This can happen if the field is Required, but no value is supplied.

It can also happen if the field's Allow Zero Length property is set to No
(as it should be), but you attempt to add a zero-length string instead of a
Null.

And there is a Validation Rule for the table (in the Properties box in table
design), as well as for the fields.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"MLH" <CR**@NorthState.net> wrote in message
news:uq********************************@4ax.com...

Why would that happen?

[MLH]

You're right. I was running up against the ZLS thing. I've implented a
work-around. Thx.

xxxxxxxxxxxxxxxxxxxxxxxxx

This can happen if the field is Required, but no value is supplied.

It can also happen if the field's Allow Zero Length property is set to No
(as it should be), but you attempt to add a zero-length string instead of a
Null.

And there is a Validation Rule for the table (in the Properties box in table
design), as well as for the fields.

[MLH]

Good suggestion. Will do.