>Generaly in all my apps I have system maintenance functions. On of them is to pack the database. Any strong reasons against this? It just seems very inefficient to try and gain exclusive access on a multi-user system on every exit of a form. Most users can handle the fact that they need to run system maintenance once a day, week, month.... what ever depending on the system's usage.
Hi Chad,
I too have system maintenance functions. Obviously if there are a large number of users, the opportunity to gain exclusive access to a table when closing a form is small -- but it actually does happen with astonishing frequency. The purpose of aPackList[] and its associated method .packtable() is merely to take advantage of those times when exclusive access can be gained to perform necessary system maintenance. Packs are very fast, and for the most part the user does not notice the slight delay in closing the form -- what's one more slight delay in Windows?
regards,
Jim Edgar
Jurix Data Corporation
jmedgar@yahoo.comNo trees were destroyed in sending this message. However, a large number of electrons were diverted from their ordinary activities and terribly inconvenienced.