Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

I would like to ask if MS Access database supports working in networks & multi-user access?

share|improve this question

migrated from stackoverflow.com Nov 24 '12 at 9:38

This question came from our site for professional and enthusiast programmers.

1  
That is a large question. Yes, it does, within limits. office.microsoft.com/en-ie/access-help/… –  Remou Nov 23 '12 at 19:12

1 Answer 1

up vote 4 down vote accepted

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:

http://www.kallal.ca/Articles/split/index.htm

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:

http://www.kallal.ca//Wan/Wans.html

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.