Hi Steven,
I suggest that when the pack routine starts, you create a file pack.go, and that you always check for the pack.go file on startup. If the pack.go exists, your users gets a warning and are asked to restart the program in a minute or two. After tha packing, you delete the pack.go file. I have used this procudere for many years.
>I would like some advise on packing my app tables. Currently I have my app set up so that when the first user logs on to the app each day a cleanup procedure runs. Each table I want cleaned is set to exclusive, packed then Use In 0 is performed. One draw back to this is not everyone logs off every evening so there may be several days when the app does not have only one user having use of the tables. The second draw back is every once in a while two users log in at approx the same time. While the one user has the tables pulled up exclusively the other user gets an error that File access is denied. Every thing is okay after the cleanup is process. Any ideas on improving this process would be welcome?