>I have a single user system I'm playing with. I have 6 files in the DE, three of which have Exclusive set on. If I run the form, and do a pack, then it works just fine.
>
>If I run the whole app from within VFP, or make an EXE and run it, and run the form from that, when I try to Pack, I get a warning that the table must be opened exclusive.
I think it is better to use a separate form or program to PACK your tables:
set exclusive on
use Table1
pack
use Table2
pack
...
Or, better, loop through all tables in a directory.
This program would be called once a month, for maintenance.
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)