Delete duplicate records from two databases. 
Author Message
 Delete duplicate records from two databases.

Hi All,

I have two identical tables in different databases, I want to be able to
check for any duplicate records and delete them from both tables.

I have tried linking the tables and looping through the fields comparing one
value to the other, but this causes problems when there are null values in
the record.

Can anyone shed some light on how to achieve the task?

I am using VB6 SP4 with ADO 2.5 and Access 2 / 97 databases.

Many Thanks

Steve.



Fri, 07 Mar 2003 03:00:00 GMT  
 Delete duplicate records from two databases.

Quote:
> I have two identical tables in different databases, I want to be able to
> check for any duplicate records and delete them from both tables.

I have a collection of connections to different databases as I works with
multiple databases simultaneously.  I iterate through the items in the
collection and do the deletion for each database individually.  It does work
and quite well  as I'm not opening and closing connections all the time.
But I will admit the for every 3 databases, approx 1.5 secs is added to the
time it takes to run.

In my particular application this is not a major issue as delete operations
will not be done that often and I control duplicate records.  However, if
you or anyone else know of a faster way to do the task it would be greatly
appreciated.  If you are deleting from 6 or more databases at a time the
time delay becomes quite noticable.
------------------------------------------------------------
Judy Mohr
Software Development
Specialised Manufacturing Solutions Ltd.

www.smsinternational.com



Sun, 09 Mar 2003 11:45:49 GMT  
 
 [ 2 post ] 

 Relevant Pages 

1. I am getting duplicate records, I mean everything is duplicate even Access record number

2. deleting duplicate records

3. Delete duplicate records ...revisited

4. easy way to delete duplicated records?

5. Deleting Duplicate Records in a Table?

6. Delete Duplicate Records

7. Deleting Duplicate Records In A For Next Loop

8. How do you delete duplicate records from Access table

9. Help Deleting Duplicate records

10. How to Delete Duplicate records in Access Table ??

11. Help: delete duplicate records

12. Deleting Duplicate Records In A For Next Loop

 

 
Powered by phpBB® Forum Software