I am running the below query on around 100,000 records but it is taking ages, do not know why.
Code:
UPDATE [tmpMaster] INNER JOIN iMaster ON [tmpMaster].[Name1] like "*" & iMaster.mName & "*" SET [tmpMaster].[iCode] = [iMaster].[iCode];