>Hi All!
>
>What is the best way to pack a table in a multiuser env?
>Is there any way to detect if a table is open by other users.
>I need to do some cleanup when the program is terminated, if
>the table is not in use.
>
>
>Best regards
>
>Per Simmersholm
Per,
Marc & Vladimir both had excellent suggestions. Is your system running 7 days/24 hrs. per day? If not, then have an app that starts the reindexing/packing during the off hours. Then there should be relatively little trouble getting access. Of course, if your users are like MY users someone will have left his computer on-line. With us, it's the customer service reps who log in via PCAnywhere - and leave it connected over the weekend :-)
Vladimir: Packing isn't just used to get rid of deleted records. If you are actively using memo fields then packing is necessary to reduce memo bloat. The last time I packed our primary data table I had the same number of records as when I started, but the FPT was 1/4 the size.
Barbara