Access Auto Matching Duplicates?

Jul 26, 2017
Reaction score
My business wants to use Access to keep record for all of our customer files. We have many offices and entry will be happening by multiple users. In addition one larger office wants to import their information into this database from their existing software. My concern is duplicate entries. I know how to put a prompt in place to prevent a duplicate entry but I'm concerned it would cause an error in an upload. I also know we can run a query to remove duplicates but with our volume that seems a little daunting and if duplicates aren't caught right away we will end up with 2 offices having 2 different file numbers for the same customer. I'm looking for a template that may have something already built it to either auto match or prompt to match duplicates, I think. Other ideas or input would be greatly appreciated. I'm hoping Access can work for us but we are also open to other solutions. Thank you!!

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question