General discussion


Trouble with append query in Access 2000

By daniella.palazzola ·
I am running a valid append query in Access 2000. I get an error that it can not append due to validation rule violations. Has anybody experienced this? This problem seems to be associated 2000, and I have not had trouble in previous versions..


This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Comments

Collapse -

Trouble with append query in Access 2000

by yatst In reply to Trouble with append query ...

The new version of access is using a different Jet Engine that operations more like SQL. If one record is incompatible it will roll the whole function back.

Check to make sure all of the fields have valid data. i.e. you don't have a date field with text in it or a numeric field in the one tabel being appended to a a numeric field that is short integer or byte.

It is also possible it doesn't like a one to many join.

Related Discussions

Related Forums