>>>What are some realistic limits as far as concurrent users for Access 97 or 2000?
>>>Are there serious data corruption issues to deal with? For example in Access2, when a workstation locked up, the record lock remained on, and it would slowly corrupt the database.
>>
>>As far as max concurrent users before you start noticing a performance degradation in Acc97 or Acc2000 would be 5.
>>
>>Don't know about the corruption.
>
>How steep of a performance degradation does it start becoming at 5+ users? We have a potential client that is "cheap", but probably won't spring for a M$ SQL solution. They have 15 users and I was just wondering if this would just spell disaster.

From a user's perspective, a noticeable performance degradation comparable to being on the internet on a 19 kbps connection. You probably haven't experienced that, the point is the user will complain and deem it close to unacceptable. The kind of thing that comes back to bite you, even when you expressed the drawbacks clearly to your client.

When you say 15 users is that concurrent or 15 total users? Maybe if you do an analysis the 5 user threshold will be seldom reached.

The next best thing to a SQL Server solution that would scale much better than Access is a Visual Foxpro solution.