Hi Lynda.

>If I needed another reason to avoid VFP tables (and I don't) this would suffice. Even though the local views are parameterized, the entire table is loaded onto every desktop each time the view is opened. The waste of resources and the giant security loophole are even more significant because many of the users run the app over a 28.8 or 56K unsecured phone line. Is this unavoidable where VFP data is concerned?

I'm afraid it's unavoidable unless you use a n-tier design in which the data access is done on the server side.

Doug