Hi Gerard,
I would use private DataSessions, but open the tables in the startup program as well. I think I tested this way back when and found that VFP is smart enough to essentially use again. So a USE SomeTable in Main.PRG may get the table info into some structure in VFP, and when your form loads, it does a USE SomeTable, but this one is much faster, since VFP finds in info in memory and doesn't retrieve it again.
>Hi Alan, Thanks for your reply.
>
>I did 'TRY' to take the files out of the DE and open them all up in a startup program but ran into problems as most of my forms rely on Private Data Sessions , so that there is no conflict if a user has say 3 screens open at the one time, all of which, say use a Cutomer file .
>
>Do you know if there is a way around getting the record pointers screwed up without Private Data sessions in the DE
>
>regards,
>
>Gerard
Charlie