Hi Russell,
I ran across this today:
http://support.microsoft.com/default.aspx?scid=kb;EN-US;q168549It's a little outdated and doesn't draw a large distinction between Access and VFP. Here is a quote:
"A rule of thumb that is expressed in terms of number of users or size of database runs the risk of inaccuracy and is also subject to becoming outdated very quickly, as products are improved. For example, with proper tuning, the current version of Microsoft Access can certainly handle 50 concurrent users and 100 megabytes of data, whereas previous versions could not."
>Thanks, Joel. I knew that was there, but they just don't quantify it. In other words, they aren't saying "if you're over X number of users and Y table size (in records) you will find better performance using VFP." It seems like they did that at one time . . .
>
>
>>>I need to *quickly* find the MS site where they talk about the appropriate environment for Access programs and how many records and users it can comfortably support. Any help would be appreciated.
>>>
>>
>>I think it used to be in the VFP FAQ at
http://msdn.microsoft.com/vfoxpro/productinfo/faq/default.asp. It seems to have a little less info now, but does mention Access vs. VFP.