Validation Rule Error

[RyanL]

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.

[Allen Browne]

Re: Validation Rule Error

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" <ryanl_01@hotma il.comwrote in message
news:1152111204 .928934.287130@ m79g2000cwm.goo glegroups.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.