Computer Problems? Computing.Net has over 1,000,000 posts about all things technology related! Over 90% answered within 24 hours! Click here to start participating now! Also, be sure to check out the New User Guide.
Remove Duplicate Records in Access
Name: confused725 Date: July 12, 2004 at 13:15:19 Pacific OS: Win XP CPU/Ram: Athlon XP/768MB
Comment:
Can anyone please tell me how to remove duplicate records from Access 2000. I have a database with over 400,000 records and I have a lot of duplicates. Whats the easiest way to do this.
Name: Bryco Date: July 12, 2004 at 15:15:17 Pacific
Reply:
I don't know Access well enough to help but the folks at OzGrid Access/Excel forum board have written macros for me to remove duplicates in Excel and I'd bet they can do the same (similar) for you for Access.
Regards, Bryan
0
Response Number 2
Name: Jennifer SUMN Date: July 12, 2004 at 18:12:32 Pacific
Reply:
This is very simple now, actually. Create a new query from the table. Use the "Find Duplicates Query Wizard." Just follow the prompts. You can access this from the toolbar. Open the Queries Window. Select "New" and then the Find Duplicates Query Wizard.
0
Response Number 3
Name: m0nkmaster Date: August 19, 2004 at 09:07:59 Pacific
Reply:
Thanks Jennifer, after your advice I've found the duplicates query wizard and all of a sudden everything now seems so simple! :-)
Summary: I want to select specific records in an Access database consisted of up to 100,000 rows. The specific column, that I want to pick up the records from, starts from A00 to U99. Each record can be from 3...
Summary: Hi I couldn’t get my answer and I thought I should post it another time: I want to select specific records in an Access database consisted of up to 100,000 rows. The specific column, that I want to ...
Summary: There is no record limit in Access 2000, but there is a file size limitation which is <= 2GB. Life is more painless for those who are brainless....
0 
