As a developer predisposed to using Access only as a database I would not use it as a front-end. Since, I can code and create database, I would naturally go for C# and SQL Server solution. But sometimes Access is useful for a quick solution.

I am talking about users who do not have enough experience in creating applications; but who just need something to get their job done.

I am sure you will agree that all IT does not run on the BIG systems, eventually the small Perl utility or the Excel sheet or the Access database is used by the end-users to accomplish tasks.

I have seen 20 users trying to use Access concurrently, and run into problems. I have read at Experts-Exchange.com people claiming they have had no problems with 50+ concurrent users. It is about how they split the app and mdb part, I guess.