well I don't know I'm far from an expert either. As they say there are many ways to skin a cat so I keep trying to find a more...

Sorry got ahead of myself but you probley picked it up when I said scrub that yes I want all rows updated

Thanks for the reply. I want to combine because I really have 8 different tables that I need to scrub in a database and while I can run each...

Sounds great I tried but get this error :

runtime error 3251 object or provider is not capable of performing the action also looked at your VB code my machine...