>Now that I got VFP8 I now have the ability to open tables in code (not in the dataenvironment) and not have them blow the whole dataenvironment out, but I started re-coding a lot of my programs taking them out of the data environment and coding them directly to open in code. The problem is something keeps closing them. It seems to happen when the code goes to the main prg to retrieve a function that uses one of the tables. What is the easiest way to open tables from a starting point which you want to remain open until the form is closed, even if you go off to main to call functions, etc.? Where should I open my free tables at? How do I keep them open unless I issue the use on them to force a close?
You should open the tables in the Form.Load() Event, or in a program invoked from Form.Load().
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)