>Dear all,
>
>I used the below code to control other user access to the same database. I able to get the error no. in order to control it. But sometime the problem "Data Environment is already unload" is encounter or Open table dialog box is appeared during the process.
>
>Why? Is there any solution to solve this problem ?
>
>Example:
>*================================
>CLOSE DATA
>SET EXCL ON
>OPEN DATA (database name)
>
>ON ERROR DO error()
>
>USE (table1)
>REINDEX
>
>(may use the same table again to process other updating)
>
>CLOSE DATA
>SET EXCL OFF
>
>*=========================
>
>Thank you very much for your kindness!!!
If you do it in form with open DE tables, then you also should take care of this, i.e. include Thisform.Dataenvironment.Closetables before start and Thisform.Dataenvironment.Opentables when you finish.
Edward Pikman
Independent Consultant