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