>Dear Borislav,
>
>Sorry for my redundancy.
>
>I mean that after CLOSE DATABASES ALL, then zip, reindex, then when I return from these routine back to the form. I cannot visit the database again.
>
>As I follow the suggestion from you to have statement OPEN DATABASE XXX at the end of the routine, I still can not run a statement =requery("AView").
>
>I ask is that normally what should I do after a CLOSE DATABASES ALL statement.
>
>
>
>
>Regards,
>
>Ransome
Ransome,
Such actions ARE NOT DESIGNED to work when someone work also!
You must have EXCLUSIVE access to tables. So No other forms should be opened, NO OTHER user should work.
These tasks should scheduled to 3 AM ;-)
Don't relay on CLOSE DATABASE. What If you have forms with Private Datasession? What If some other user works with tables?
You should have something that gives you exclusive use of tables that shows you that there are no other forms opened and no other user works with tables.
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.