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?