By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,482 Members | 2,438 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,482 IT Pros & Developers. It's quick & easy.

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

P: n/a
MLH
Why would that happen?
Nov 13 '05 #1
Share this Question
Share on Google+
4 Replies


P: n/a
MLH wrote:
Why would that happen?


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

--
[Oo=w=oO]

Nov 13 '05 #2

P: n/a
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?

Nov 13 '05 #3

P: n/a
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.


Nov 13 '05 #4

P: n/a
MLH
Good suggestion. Will do.
Nov 13 '05 #5

This discussion thread is closed

Replies have been disabled for this discussion.