>Is there any way that when using a "Select * from table1 into ..." statement that you can prevent "table1" from opening? I have been using "use in table1" to close them. I am trying to limit the number of files open at any time.

I want to add the following details to Dragan's comments:

It seems obvious that VFP keeps the files open for performance reasons. Closing files and re-opening them is slower than selecting an open file.

If you have a private datasession, the form will close all open files anyway, as soon as you close the form.

Hilmar.

Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)