>>Thanks.
>>
>>If I open all my tables at the beginning, and I'm using Private Datasessions in the forms, then I may have problems with that.
>>
>>Kev
>
>
>No, you won't. VFP will do a USE AGAIN in the data session.

One of the problems experienced could be VFP not respecting SET REFRESH when initially opening tables in the datasession 1 and then using private datasessions (PDS). Yes, the tables will be opened faster in the subsequent datasessions, but older data may exist from time to time (e.g. printing reports).

A workaround for this that was documented here (in a previous post) and in the VMP docs is to RLOCK() and release a table in the subsequent PDS when you wanted to be sure you had the most recent data. The RLOCK() forces VFP to update the local cache.