Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Deleted Record Cleanup
Message
From
23/03/2004 03:57:57
 
 
To
22/03/2004 20:02:34
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00888717
Message ID:
00888764
Views:
7
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?
Previous
Reply
Map
View

Click here to load this message in the networking platform