Lisa,

Did you ever determine the cause to your problem? I am having a similar problem with a "File in Use" error when trying to delete a database I create dynamically.

Thanks,
Bill

>We seem to be getting Error msg 3 "File in Use" quite alot.
>
>What we do is create local tables dynamically from a FoxPro 6 front end to run a Crystal 7 report. For a while we thought that it was only Crystal's problem, but recently we have seen other programs "hold on" to a file, even after the data environment has been released. (Crystal may still be the culprit).
>
>We seem to get it only when the method to create the tables dynamically runs, but not everytime.
>
>We load Cyrstal with with the Crystal active X control on our forms.
>
>Any suggestions?