Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Null error with append query

Status
Not open for further replies.

kdoran

Technical User
Joined
Mar 23, 2003
Messages
88
Location
US
I am trying to append query from one db to another one (tried a linked table or directly to it). The table is exactly the same. When I run it I get an error message. Here is error message I get.

Cant append all the reocrd in the append query.

Db set 0 fields to Null due to a type conversion failure, and it didn't add 3 records to the table due to key violations, 0 records due to lock violations, and 0 records due to validation rule violations.

any ideas,

Kelly
 
Kelly,

You had three records that were not appended because of
duplicate key violations. The field that you are using
as a key field (indexed, no duplicates) already exists
for those three records.

Wayne
 
Is there any way around this?
 
The "way around it" is to change the index on the fields that are duplicated to "allow duplicates". You can't do that however, if those fields are part of the primary key. By definition, a primary key must be unique (i.e. no duplicates.)
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top