If you put Access on the desktop with read access to SQL Server tables, it's great for letting people do their own ad-hoc reporting.

You can give write access, too, but you start getting back into the concurrency issues ... which are still not as bad as just sharing the .mdb.