Hi Bianca,
With a properly designed application, the answer is most certainly yes. Here
is an article that should be very helpful to you:
Implementing a Successful Multiuser Access/JET Application
http://www.accessmvp.com/TWickerath/articles/multiuser.htm
The golden rule is to "request only the needed data". In other words, don't
design forms that open up to hundreds or thousands of records. It is much
better to have a search form that allows a user to find a particular record.
Then they can open that one record for editing. This helps to avoid
unneccesary network traffic. See the following download for an example:
Query By Form - Multi Select
Tom Wickerath, February 12, 2008
http://www.seattleaccess.org/downloads.htm
It is much easier if you are only dealing with a LAN (local area network) in
a small office, versus trying to use a WAN (wide area network). If you have
to deal with a WAN, then you need to use Terminal Services. Access MVP Albert
Kallal has a great article on this topic:
Using a wan with ms-access? How fast, how far?
http://www.members.shaw.ca/AlbertKallal/Wan/Wans.html
With proper design and attention to detail, you can do this.
Tom Wickerath
Microsoft Access MVP
http://www.accessmvp.com/TWickerath/
http://www.access.qbuilt.com/html/expert_contributors.html
__________________________________________
