Using Pack on a shared table

[kindred]

What's the best way to deal with packing tables within a database when it is shared by other users? I have no problem sharing it, but since it needs to be opened exclusively,

I'm at a loss to how to deal with when and how to pack the table. One note... when the tables are being shared... they are being accessed only through local views created.

Maybe there's a way to check who is using the tables and who is not?

Or is there a way to perminately delete these records out of the tables while its being shared? (currently i use the DELETE - SQL cmd to mark then)

Thanks,
Stephen Hardie

 

[ramani]

Follow the thred below...
thread184-67376
wherein I have suggested how to control number of users in the system. So when you are in as a SImgle User, you can USE MyFile EXCLUSIVE and do the packing or such EXCLUSIVE functionality.
Hope this helps you
ramani :-9
(Subramanian.G)
FoxAcc
ramani_g@yahoo.com

 

[wrw]

There was an application a few years ago that tracked telephone call records. It required 24x7 access and had thousands of records moving in and out of it daily. Since it could never be offline delete and pack was not practical. Instead of deleting, the key was renamed to an internal value out of accessable range. When a record insert was necessary a seek for one of these values was made first before a new record was added to the file. If one was available it was blanked and used instead.

 

[kindred]

wrw,

Thats certainly something I can consider doing.

Thanks,

Stephen