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!!!