Checked the data in JDA for checking if there are duplicates, and as per checking, there is none. cleared a count MDB and give it to Sir Anton. Advised to update a Masterfile and use the clean MDB, there might be a problem in the clearing of the MDB when executing an update. Sir Anton advised that he will try updating the Masterfile again tomorrow and advise for the result.