Professional and easy to use
free tool for MS Access
REVIEW
Dedupe Toolbox
The only free and easy tool for data cleaning and
deduplication of Access tables.
Quick intro video
How to find and remove double records in 5 mouse clicks with Dedupe Toolbox.
Try this direct YouTube link: Quick intro if the video doesn’t start! (Opens new tab.)
About Dedupe Toolbox
The Dedupe Toolbox has been available for many years and has proven record of being able to easily clean Access tables. It might not have the most fashionable interface anymore, but the programme still works remarkably well. Because it is meant for general use in any Office, no special knowledge is needed. If you know what an MS Access table and a record is, you are on your way. If required, the programme can easily perform more advanced tasks as well.
For example, if double records (field values) are found, you might want to set which of the found records needs to be retained. Or you can just as easily create a new table with unique values only, or create a new table with the double records only. This, and much more, can be done with just a few mouse clicks, exactly the way you want or need it. Because the programme first displays a result-set of the records for any action taken, you are always in control. Just check the result set, change few settings if needed, and behold the new result-set. Another nice thing is that you can also display the entire table content where the double records are marked. This is handy to view double records in an overall context and in relation to each other. This all can be done before any irreversible action is taken.
The programme will save time for professionals (no need for building queries, vba code etc.) while less experienced MS Access users can achieve results like a pro.
In short: Main functionality Dedupe Toolbox
• Search duplicate values and/or remove unwanted records easily.
• Visual control of found double values before any change is made.
• By changing the program settings:
determine which record (of found double records) will be removed.
Options
• Search duplicates in selected columns.
• Search duplicate records.
• Search duplicate values in part of selected field(s).
• Search for equal field values inside the record.
• Search missing values and empty fields in selected columns.
• View, change and edit search-result-sets.
• Create new tables from search-result-sets.
• Create new unique-value tables in a few mouse clicks.
• Export/import and linking to Access tables, and more.
Is it really completely free?
Limitations
The programme was released when all Access applications where based on the 32 bits version of MS Access. Much of these 32 bits applications still run and work fine. Over time people however started using the 64 bits version of Access as well. So hopefully the 64 bits version of the Dedupe Toolbox will be developed some day. For now, the use is limited to the 32 bits MS Access version. There are still a lot applications of course, but… it would be nice if a 64 bits version would exist as well.
First test whether the programme suits your needs. Always backup your files in advance. The programme comes as is. The maker can’t guarantee it is a solution for everyone, nor that it will work correctly in every (exotic) environment. A small bug (for tables without a unique ID field only) might occur when using the software in more advanced way. If this happens, an easy workaround is described in the provided Readme of the downloaded zip-file.
Requirements
Requirements for your pc are: minimum Windows 7 (32/64 bits) and Access 2010 (32 bits) or higher.
(Currently Access 64 bits is not supported.)
Download
Click the button below to download the Dedupe Toolbox for free. Save the file to your local drive. After download you need to unzip (extract) the file first before the application is opened in MS Access. Please, take notice of the provided “Read me” in advance.
_________
Additional video for more advanced use (if needed)
Deduplicate and preserve specific records.
Try this direct YouTube link: Advanced use if the video doesn’t start! (Opens new tab.)
________________________________________________
Who has made this tool for free available?
Dedupe toolbox was made (many years ago) by the Dutch programmer Dick Burgers. At first as an Access add-in for own use. But he made the tool available for everyone without any obligation. He found that add-ins are often not allowed, or not easy to install, in some Office environments. He more recently converted the programme to a regular Access file. For this reason the programme can be opened like any other Access application with MS Access (Installation is no longer needed ). For contact see his LinkedIn Profile. I suppose that Connections are welcome but not meant to use as a kind of helpdesk. As said, the programme comes as is. Mostly the programme explains itself or you can just try out the more advanced settings if needed
Curious
If you are not strictly limited to work-related Office things, you might be interested in his global and largest projects so far at www.999Angels.com. Some may find it (for an IT professional) a kind of curious project, but it might put a smile on your face. Any Thumb up, Link, Share or Support of this new project is appreciated. But as mentioned, there are no obligations whatsoever.
—