General information
Title:
Deleted Record Cleanup
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?
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only