>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