MS Access - Limit to # of shared users
November 23, 2009 7:04 PM Subscribe
Is there a limit to the # of users who can share a Microsoft Access database across a network?
posted by cg1 to Computers & Internet (12 answers total) 1 user marked this as a favorite
I've been working in Filemaker for so long that it's been a while since I designed in Access. I'm now working for a public school that has no money, but all its machines have Access. The school *really* needs a database, so I'm considering building one using expertise from my previous life in the business world.
- Assuming all 100 teachers in our school has Access on the PC in their classroom, could all 100 access the same Access database simultaneously without problems? I know that Filemaker has a user limit of 250, but that requires Filemaker Server (a separate / more expensive software) be installed on at least the server itself. Does Access have similar limitations?
- Does Access support a web-based module, that teachers not in the building / not on the school network could access? If so, is it worth a damn?
- Is Access easier to design in now than it was years ago (when I switched to Filemaker and was thrilled how much simpler it was)?
Thanks in advance for any help,