validation rule error - append query

G

Guest

Hi
I'm trying to append an access table to another access table, and I received the following error "Microsoft Access...didn't add 8657 records due to validation rule violations". I've checked and double-checked: my 2 tables have identical designs - fields types, widths, and neither have any validation rules or validation text set. Any ideas what the problem is and how to overcome it

Thanks
T.
 
A

Allen Browne

Sometimes these are not obvious to find. These may help track it down.

1. Is your append query trying to assign values to the primary key field?
Could that be the source of the duplicate?

2. Do you have any other fields that are "Indexed: No Duplicates"? Any
compound indexes?

3. Is the query assigning values to a field that is a foreign key to another
table? Is it possible that these values do not match the values in that
other table?

4. Is there a validation rule on the table itself (i.e. in the Properties
box in table design view, as opposed to the Validation Rule for a field,
which shows in the lower pane of the table design window)?

5. Does the query attempt to assign a string with no characters in it (as
opposed to a Null value) to a text field that has its Allow Zero Length
property set to No?

6. Is there an Default Value in one of the fields that is NOT being assigned
by the query? For example, a foreign key with zero as the Default Value?

7. Is there data that is outside the range a field can accept, e.g. an
integer larger than 32767, or a Null to a Yes/No field?

8. Is one of the query fields arriving in a format that Access is not
understanding, e.g. for a date, or for a currency?

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

warbler said:
I'm trying to append an access table to another access table, and I
received the following error "Microsoft Access...didn't add 8657 records due
to validation rule violations". I've checked and double-checked: my 2 tables
have identical designs - fields types, widths, and neither have any
validation rules or validation text set. Any ideas what the problem is and
how to overcome it?
 
J

John Vinson

Hi,
I'm trying to append an access table to another access table, and I received the following error "Microsoft Access...didn't add 8657 records due to validation rule violations". I've checked and double-checked: my 2 tables have identical designs - fields types, widths, and neither have any validation rules or validation text set. Any ideas what the problem is and how to overcome it?

Thanks,
T.

Most likely you have a Relationship defined between the target table
snd some other table, and there are no records in the other table
which match the data you're adding.
 
G

Guest

Thanks to both Allen and John for their replies, and I apologize for the delay in my reply (I've been on vacation). The problem seems to be solved - yay! My table had no relationships established, nor a primary key setup, but it did have 'allow zero length' set to NO in numerous fields. After changing these to YES, the data was appended without a hitch

Thanks again for your help
Theresa (warbler)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top