Closeing files problem

[mallee]

In a utility menu form of my app I want to close all the
files (free tables) in order to re-create the indexs.
I intend to exit VFP after re creating so I issue
deacti wind all
deacti menu all
release wind all
clear events
close all
use xxx exclu

VFP tells me xxx is in use. No files show up is disp stat.
I have used xxx in a DE earlier but wouldn't the code above
release them ?

Is there a way to find out what is using file xxx ?

 

[bettyfurr]

what I do when I want to close a table and reopen. I know this table and only this table is closed.
if used('filename')
select filename
use
endif

use filename excl
select filename
index on indexname tag indexname

Hope this helps.

 

[wgcs]

You may have the table hanging around in a different DataSession...

When you have the problem, issue the command SET, then use the datasession combobox to see if there are any DS's other than the Default DS.

 

[mallee]

Thanks wgcs, that was just the tip I needed.

 

[wgcs]

Do I get a star?