append query key violations

[Jacquie]

I need to run a query that appends records from a table to the exact same
table in another database. I run it, and it it refuses to add the new records
saying that there are key violations. And yet if I do a copy and paste
append, it will work.

I've done all the obvious -- made sure the primary key wasn't duplicated,
made sure referential integrity wasn't violated, etc.

Any ideas? thanks!

 

[Steve Schapel]

Jacqui,

Can you post back please with the SQL view of the Append Query?

 

[Jacquie]

INSERT INTO Students ( UI, IDCon, FName, LName, BusEmail, Address, City,
State, Zip, Zip4, EMail, IndPhone, CellPhone, DayPhone, CareType, Comments,
FCCCertified, CountyContract, HomeCenter, Business, BusAddress, BusCity,
BusState, BusZip, BusZip4, BusFax, DOB, SID, BusPhone, BMonth, BDay, OELov,
ITov, NEW ) IN 'K:\CCC Database.mdb'
SELECT iStudents.UI, iStudents.IDCon, iStudents.FName, iStudents.LName,
iStudents.BusEmail, iStudents.Address, iStudents.City, iStudents.State,
iStudents.Zip, iStudents.Zip4, iStudents.EMail, iStudents.IndPhone,
iStudents.CellPhone, iStudents.DayPhone, iStudents.CareType,
iStudents.Comments, iStudents.FCCCertified, iStudents.CountyContract,
iStudents.HomeCenter, iStudents.Business, iStudents.BusAddress,
iStudents.BusCity, iStudents.BusState, iStudents.BusZip, iStudents.BusZip4,
iStudents.BusFax, iStudents.DOB, iStudents.SID, iStudents.BusPhone,
iStudents.BMonth, iStudents.BDay, iStudents.OELov, iStudents.ITov,
iStudents.NEW
FROM iStudents;

 

[Steve Schapel]

Jacquie,

I am very sorry, what you have done seems straightforward, and I can't
think of why you are getting this error.

Can you please re-post your question to the Queries newsgroup, as it
will more likely get seen by a wider group of people over there.