Thanks for the info.....!

>
>You could do that, but if you do, I would put a timer in it manually. Such as:
>
>

>
>SELECT auditbat
>

-SNIP - 

>

>
>How long does it typically take to run that process? Have you tested update times?


These processes take less than 30 seconds each....

>
>Or you could do conditional searches for your records that match your condition and update each record accordingly. That's the approach I usually take and I lock the record before I update it and unlock it again. These are the solutions I've used ONLY when I cannot use buffering for whatever reason.

Yeah... these tables are FREE tables.... so guess I need to use FLOCK and RLOCK

Thanks once again!
Tommy