By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
448,921 Members | 1,875 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 448,921 IT Pros & Developers. It's quick & easy. Appen Query to Access DB

P: 6
I have an Access DB backend for the application I am running, I want to use the built in ability in Access to remove duplicate entries...

Say I have table1 with fields field1 field2 and field3, none of the fields are indexed without duplicates for a reason...

The way I remove duplicates is to do an append query into an identical table that has one of the fields set to indexed no duplicates.

If I run this query in Access directly I get a message box saying "Microsoft Access can't append all the records in the append query" and it removes the duplicates that would cause a violation of the uniqe rule... then i delete everything from the first table and move the data back.

Now if I try to do the same thing from the application, it just errors out and I cant find a way to ignore the violation so it drops the duplicates.

Does anyone know of a way to force the append query ot ignore the violation in

PLEASE PLEASE PLEASE, any help would be extremly appreciated.
Sep 22 '08 #1
Share this question for a faster answer!
Share on Google+

Post your reply

Sign in to post your reply or Sign up for a free account.