Hi Gerard,
The applications all run on a LAN, so USE table times are all pretty insignificant. I do use a lot of datasessions and have almost no modal forms so a user can have lots of instances going at once. For example a private data session form might also have a combobox on it that creates its own private datasession to maintain an array to populate the combobox. I don't want the business object that the form is concerned with to have anything to do with the populating of a combo that's on the form. I might use that combo class anywhere, with or without the business object that the form cares about.
So normally, yes, there are a bunch of open tables in various datasessions and therefore, each new USE is not so new to VFP and should be quite effecient.
>Hi Charlie.
>This seems to be what I am looking for ...
>
>Do you currently use this scenario in any of your apps ?
>
>Regards
>
>Gerard
>
>
Charlie