>Hi Hilmar,
>
>Thank for your suggestion.
>
>The reason why I want to switching 2 forms, is that:
>
>Form1 is the main form and Form2 is form for zipping, reindexing and packing, I find that at Form2 I close the databases for zipping, reindexing and packing. I would unable to visit the data in Form1 sucessfully. Releasing forms and do form seems solve that problem. Am I right ??
>
>
>
>Regards,
>
>Ransome

Yes, if you close forms that use that table, you can PACK, etc. But there may also be other users that are using the table. At least, you should seriously consider the possiblity that your application will eventually be a multi-user application. In this case, not only open tables on other forms, on your same computer, can interfere with a PACK, but also open tables on other computers.

Your maintenance form - especially for reindexing and packing - should be opened late at night, when nobody is using the computer. For an emergency reindex, all users should exit the application - or be forced out (I can give you more details if you are interested). PACK, on the other hand, should only be done once a month. Finally, the person doing the maintenance should know what he is doing - so requesting that administrator to close all other forms should not be too much trouble for him. However, you can have a procedure that closes all open forms if you like, and call it up before opening the maintenance form.

HTH,

Hilmar.