>>>The company I am working for is mulling replacing VFP with Access (yikes!). I am sure most of you would agree from a professional development stadpoint, this would be a disaster (and probably drive me to a new job). I want to know if there is any sort of articles out there that compair the features of the two to help me make my point that it would be a huge mistake to make such a change. Thanks!
>>>
>>>-Matt
>>Hi Matt,
>>Allison Balter's book on Access (ISBN:0672309440) puts as a rule of thumb that: "with 10-15 concurrent users and more than 100,000 records, poor performance generally results". This is for systems that are not Client/Server (use of access native database files).
>
>
>These are the numbers frequently used by Microsoft too. FYI, the new MSDB, which is coming in Access 2000 has many of these same limitations, and a 2 table size limit.

Craig,

You've really helped me a couple of times, and I value the accuracy of your answers.

What a great rumor: "Well-respected source says Access 2000 is limited to 2 tables."

ROFL!!!!