468,242 Members | 1,727 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 468,242 developers. It's quick & easy.

vb.net Appen Query to Access DB

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 vb.net 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 vb.net?

PLEASE PLEASE PLEASE, any help would be extremly appreciated.
Sep 22 '08 #1
0 1085

Post your reply

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

Similar topics

8 posts views Thread by Adam Louis | last post: by
12 posts views Thread by Joe Stanton | last post: by
22 posts views Thread by Stan | last post: by
3 posts views Thread by mnjkahn via AccessMonster.com | last post: by
reply views Thread by kermitthefrogpy | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.