>What is the realistic upper end of table file size before speed suffers? What about number of users accessing it?
>Our company did an install for a company that had aprox 25 concurrent users and 700MB of tables. They were a 24 x 6 operation and did a very heavy volume of orders. We could not get the speed of the searches and the reports in VFP5 fast enough to please them.
>Any real world info would be appreciated.

Give an speed example. Take one of your largests tables. Do a SQL-Select (using your indexes) reply with the time. Simple SQL statements should be subsecond. One of my tables is approaching 1 million records and queries to this table vary from subsecond to about 3 seconds (of course, complex queries take longer).