This may seem like a pretty basic question, but I'm willing to double the points if someone can give me a really good answer, preferrably with a few good links. Searching the web for this info is difficult because the word "Access" appears in many, many documents about SQL Server which have nothing to do with MS Access. I use Access a lot, but SQL Server is entirely outside my experience, so I'm sort of half in the dark here. And the Microsoft web site was not much help - I think they would rather sell you both than just one.
I have been asked to look into devloping a scheduling database for a medium sized ad agency. They expect the minimum number of concurrent users to be about 30 (that number will grow over time) and the maximum to be about 50. The database will have about 300 fields in total and will get about 1000 records added per year. They are in an NT environment.
I understand that a solution is to use SQL Server and that Access might not work well for more than about 15 users and that there may be security issues with Access.
My question: could someone give me a description of the differences and other issues between Access and SQL Server? If possible, please include the above issues (i.e. max # concurrent users, security concerns). When does MS Access stop being a viable solution (on its own)?