Is there a way besides writing code in VB 6 or .net and using the task scheduler to execute it every day when noone is on the database to run a bunch of code to go through one or more tables and change info based on certain criteria? I am the author of this replicated db at my work and using ADODB like I am to go through tables and do this gives locking errors when more than one person is on, even with adlockoptimistic set. What I want to do involves updating tracking info like weeks at a vendor based on current date and in date and priority for getting done at that vendor based on desired out date. If anyone has a way of just doing this with a macro, your help would be appreciated, as would any code that could do this using straight VB. I can't seem to find a way using the task scheduler to do anything but run a program. I've tried a program called macro express but it seems to have problems sometimes. Thank your for your time and help.