>This is absolutely not true. I have several tables that reside on server that approach a gig in size, and opening them takes no longer than opening a small table.

I also have no trouble opening tables (regardless of the size) on the LAN. So what is your explanation for the several minutes that it takes (equivalent to downloading the table) to open a table over a slow connection, whether with the USE command or ODBC SQL (to retrieve one record). On my 56K WAN it takes about a minute for a small table and then more time depending on the size of the table.

Without a back-end server (or COM) serving up the data how can VFP manipulate a table or index without having access to the entire table? As soon as I do a SQL Select it needs access to the entire table (or at least the entire table when it has to build an index on the fly).