>>Rlock() locks current record only. However, the whole idea seems to be unnecessary. Your system may check table size and if it really approaches 2GB, commands all users out and pack/archive records.
>
>Thanks for your input.
>
>That is what we are trying to avoid. There are several systems accessing this table. Some of them are 24/7 with no real user interaction. Shutting them all down (even during a maintenance window) can be a real problem. This method, as far as I can see, allows us to
>
>Move the older records to an archive
>Delete them and thereby make that space available for newer records
>
>without having to take any of the systems down.
>
I see it now. Yes, it looks like a nice solution.