Yes, there are some things that need to be addressed in that environment --
but there isn't a limit on how many people can open a file. The best
collection of information and links on multiuser issues is at MVP Tony
Toews' site, http://www.yqcomputer.com/
There are also design differences. A well-designed, good-performance
single-user standalone Access application isn't usually a well-designed,
good-performance mult-user Access application. For example, you don't want
to open a Form using a Table or huge Query as the RecordSource... use a
Where clause referencing an indexed field so you only have to bring the
index across the network to select the records for which you need to bring
the rest of the data across. It's surprising how often you only need one
record (if it exists) or none (if it does not) in a Form.
For a more general overview of Access in a multi-user environment, download
a copy of my presentation on that subject from
Good luck with your project.
Microsoft Access MVP