RE: How do I avoid key violations in append queries
- From: Duane Hookom <duanehookom@xxxxxxxxxxxxxxxxxx>
- Date: Sun, 30 Mar 2008 17:36:00 -0700
I expect you might have duplicates in a field or fields that make up a unique
index or primary key. If this is the case then change your append query to a
totals append query.
--
Duane Hookom
Microsoft Access MVP
"Pitaofauck" wrote:
I am using Access 2007 in Access 2002 - 2003 file format. When I run an.
append query from a table with 129 records, to a table with 0 records. I get
the following message:
Microsoft Office Access set 0 field(s) to Null due to a type conversion
failure, and didn't add 100 record(s) to the table due to key violations, 0
record(s) due to lock violations, and 0 record(s) due to validation rule
violations.
If I agreee to run the query anyway it appends 29 records to the new table.
- References:
- How do I avoid key violations in append queries
- From: Pitaofauck
- How do I avoid key violations in append queries
- Prev by Date: How do I avoid key violations in append queries
- Next by Date: Re: Sorting by Week and Year
- Previous by thread: How do I avoid key violations in append queries
- Index(es):
Relevant Pages
|
|
