The easiest way is in stead of running an update query, just copy all the records from the duplicates table into the new table with the unique key, Access will automatically paste the duplicate rows in to a new table called “Paste Errors”. I know it’s not the most fancy way but it works.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.