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 Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Delete duplicate records
Thanks Simon, Michael for your tips. Unfortunately not quite what I need, I have a key index set on each table which I can sort by, usually made up of three or four fields. I have approx 60 tables with about 40 fields in each, with around 60,000 records in each table (In know, I have said...- cdotec
- Post #4
- Forum: Visual Basic (Classic)
-
Delete duplicate records
I have two Access 2 db’s, with identical tables in them; I need to delete matching (duplicate) records in both db's I am using VB6 (SP4) and ADO / ADOX 2.5, I have tried joining (linking) the tables and then looping through the records, but this causes a problem when the records have null...- cdotec
- Thread
- Replies: 4
- Forum: Visual Basic (Classic)
