Will a server allow multiple users to work with a Microsoft Access database at the same time?

by on February 12, 2013

Q: Would a server allow multiple users to work with a Access database and make changes at the same time? If so which type of server would be best for a small business less than 10 users?


One Response to “Will a server allow multiple users to work with a Microsoft Access database at the same time?”
  1.  
    Picked as best answer

    Yes a server will allow multiple users to make changes to a MS access DB at the same time. I would suggest that you use a version of MS Windows 2008 Standard/2012 Standard. Technically – For each user that is connecting to the server share you need to have a CAL (Client access license).

    You can also go a workstation route. Windows 7 will support up to 10 concurrent windows connections. Once you go above 10 users it will require you to switch to Server version of windows.

    If budget allows I suggest that you go with a server version of windows as it will allow you to grow your environment in the future if need be, It also allows for better user/file share permissions management. Overall it will give you a better file sharing experience with room to grow.

    Let me know if this fully answers your question.