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

Validation Rule Error

P: n/a
All, I have an append query set up that pulls records off of one table
and appends them to a linked table. However, when the query runs, it
gives me an error message saying that the records could not be appended
due to a validation rule error. The wierd thing is there are no
validation rules set up for any of the fields in either table. All
fields are the exact same type and have the same properties. Any
thoughts would be greatly appreciated.

Jul 5 '06 #1
Share this Question
Share on Google+
1 Reply


P: n/a
See:
Why can't I append some records?
at:
http://allenbrowne.com/casu-19.html

The article suggests several items to check for validation rule violations.

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

"RyanL" <ry******@hotmail.comwrote in message
news:11**********************@m79g2000cwm.googlegr oups.com...
All, I have an append query set up that pulls records off of one table
and appends them to a linked table. However, when the query runs, it
gives me an error message saying that the records could not be appended
due to a validation rule error. The wierd thing is there are no
validation rules set up for any of the fields in either table. All
fields are the exact same type and have the same properties. Any
thoughts would be greatly appreciated.

Jul 5 '06 #2

This discussion thread is closed

Replies have been disabled for this discussion.