I would like to ask if MS Access database supports working in networks & multi-user access?
- Anybody can ask a question
- Anybody can answer
- The best answers are voted up and rise to the top
migrated from stackoverflow.com Nov 24 '12 at 9:38
This question came from our site for professional and enthusiast programmers.
Access most certainly supports a network and multiuser operation right out of the box. You don't have to change your code or really do anything special.
However to keep in mind while Access is tremendously easy to use on a network, and many people often utilize access with multiple users on a network, it has its limitations.
There are many issues to consider, but the basic concept is that your network has to be very solid, I can't say the network has to be above average, but Access as a product in a network environment is quite sensitive to poor connections.
So if you're just talking a couple computers on the Office Network and you share a folder on one of the computers or your server, then access can work quite well on this environment. However if your network is a wide area or has users connecting over the Internet, then such setups tend to be quite problematic.
As a general rule, it's recommended that you split your application into two parts. You place the program part on each computer, and this task is not require any extra programming skills on your part, but it does help enormously in terms of reliability.
I explain this concept of splitting and how you run access in a multi user environment in the following article of mine:
And a primer on the different kinds of networks, and some of the obstacles as you may encounter are outlined in the following article of mine: