|A common method to delete duplicates with MSAccess is as follows:|
Create a new Table with the same structure(FIELDS) as your current table.
Make the FirstName, LastName and Address fields a composite primary key. (One primary key made up of these three fields)
Create an append query, and copy your original table to the new table. Access will do the copy and will tell you there are 9000 records that can't be added because of key violations. These are the duplicates.
So you new table won't have the duplicate records.
And you still have the original data(all records) in your current table.