Remove Duplicate Records in Access
I am working on a project and I am storing large amount of data in Access. I needed a quick an easy way to remove duplicate records based on a specific field in one of my tables. I thought, “This shouldn’t be too hard since there is a query wizard to determine duplicate records.”
Man, was I wrong!
After about a day of trying, I figured out the following little trick:
- Make a copy of your original data table but just copy the table structure, not the data.
- Edit the new table and change the field with the duplicates’s index to No Duplicates Allowed.
- Save the new table.
- Create an append query that will append all of the data from the original table to the new table.
- Run the append query. You will see a number of warnings/errors. Simply accept them to complete the process.
- Rename the original table.
- Rename the new table with the same name as the original table.
You should now have all the duplicate records gone!

One of the annoying things about web design is the fact that you are really quite limited in the number of fonts that you can use on your website. Unless you’re really into rendering your text to graphics and adding a pile of alt tags so that search engines can see your content, there really is little that you can do.
From the Completely-Useless-But-Kinda-Fun Department, I give you the ability to edit any webpage on the Internet! Well, actually, you will only edit the cached copy of the page on your computer but you can sure make some very impressive looking webpages in short order.
As you can tell by the top of the website, my web hosting has been provided free of charge for the past while by AlwaysWebHosting. They have been extremely generous and I wanted to thank them very much for all of the help, support, web space, etc. that they have provided for me over the past while. If you are looking for a great web host, definitely give these guys a try.