>>I have a class which adds local views on-the-fly to a database. Everything has worked fine until I tried to move some of methods from a top-level form to the application object. The only difference is the application uses the default datasession. The class takes care of switching datasessions so I am covered there. It appears to be a problem using the default datasession?
>>
>>I can do the following is the class:
>> 1) SET DATASESSION TO
>> 2) SET DATABASE TO
>> 3) Checked to make sure database is opened exclusive.
>>
>>Once I issue the CREATE SQL VIEW the error occurs.
>>
>>File in use.
>>
>>The Database is created on-the-fly with the CREATE DATABASE.
>>This opens the database exclusively.
>
>The database does not have to be opened exclusively to add a view to it.

I know. I was just stating the fact that it was because it adds confusion to the error message - File in use. It is some sort of problem with using the Default data session. I have worked around the problem with a differnet approach. Something funny there.

Thanks,
Bill