>>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,
I have another concern regarding this situation - with users jumping in and out, I'd expect it to happen often enough that second user pops in while the first one is packing the tables, and then this second user will get a message (at least) or have is form issuing a "Cancel - Ignore" (in the worst). Does this happen?