>>Samuel, you need to use SELECT not USE as you suggested. The DataEnvironment takes care of opening each table in a separate workorder. Just say SELECT TABLE1 or SELECT TABLE2 when you want to look at data.
>>
>>If you DON'T have your tables in the DataEnvironment, then you would put the USE TABLE1 in 0 command in the Load method.
>>
>>HTH
>>Barbara
>
>
>Barbara, however I have to use USE to open a table. Because I want to delete all the record in that table and pack before I append new info. into it. And if I use SELECT it will gives me an error saying "file must be opened exclusively". But if I use USE command it gives me error saying "file in use". Any suggestions to over come that problem
Samuel, try removing the files from the dataenvironment and opening them with the EXCL clause in the LOAD method of your form. Be sure you close all the files in the UNLOAD or DESTROY methods if you do this.
Barbara