>Mmmmm. I do have the table open in DS1 but my form is running in a private DS. The test I just performed showed DS9. something smells fishy here!
>
>Aha! the table was used EXCL in the other DS.
>
>Thanks
>
>
>
>>The error means that table is already open in the same datasession.
>>
>>>
>>>The table is open in the default datasession and another program in another datasession is attempting
>>>
use sometable again alias "sometable"
>>>Error 3
>>>File is in use
>>>
In addition to what the others have said, opening the tables in the default data session, improves performance of subsequent use agains in private data session forms and in SQL queries etc.