In addition to Ed's suggestion, I recently came across an interesting note on the Microsoft Mastering Series CD for Distributed Application Development. It noted that Access shouldn't be considered for anything that would support more than 10 users, and that it was primarily ideal for a single user app.