shared access

[mdrummer]

What is the best strategy to set up a shared database for
50 users who input data and one administrator who prints
resulting reports?

 

[tina]

backend db (all the data tables) on a server in a shared
folder. frontend db (queries, forms, macros, modules,
reports) on each user's hard drive. do NOT put one
frontend on a server for multiple users.
however....how many people do you expect to be using the
db at the same time? all 50? access won't accept that many
users connecting to the backend db at once. there are ways
around that issue, but difficult for the inexperienced
developer to set up, and depends on your users' specific
needs.