You are here:

Using MS Access/MS Access Multiple User Access


QUESTION: I was using MS Access 2003 with Windows XP, I made a Program on MS Access 2003 for Files Entry and Status followup put it on Sharing Folder and it was working perfect, multiple users can open the program at the same time from their pc's to add/update their files.

Now the IT Department upgraded all the PC's to Windows 7 and Office 2010, the program is still working but ONE USER CAN USE THE PROGRAM AT A TIME, ON THE OTHER PC THE PROGRAM IS NOT OPENING UNTIL THE FIRST USER EXIT.

Please advise if there is way to setup it for multiple users.

Thanks & Regards,


ANSWER: By default Access is multi-user. So you need to look at how users are opening the file.

However, ANY multi-user app NEEDS to be split between back end (tables) and Front End (everything else). The back end should go in a network share and the front ends installed locally for each user.

Setting that up will prevent the conflicts.

Hope this helps,
Microsoft Access MVP 2007
Author: Microsoft Office Access 2007 VBA

---------- FOLLOW-UP ----------

QUESTION: Thanks for your prompt answer, you are right if the back end and front end are separate it works perfect but it is slow to open, BUT earlier in my XP with 2003 office the front and back together in one file worked perfect for multi-users. BUT now in Office 2010 not working, is there any way to solve this?

Thanks again

I do NOT recommend sharing an unsplit application. This is an invitation to corruption. It should not be that much slower to open. Maybe you need to look at what happens when it opens.

You need to look at how the app is launched, maybe something is happening that opens in exclusive mode. But I strongly recommend that you split it. Besides possible corruption there are many other advantages to splitting.

Hope this helps,
Microsoft Access MVP 2007
Author: Microsoft Office Access 2007 VBA

Using MS Access

All Answers

Answers by Expert:

Ask Experts




I can answer almost all types of questions relating to Microsoft Access usage and application design. My strengths are database and interface design.


I've been designing databases for over 25 years working with dBase, FoxPro, Approach and Access.

Author of Microsoft Office Access 2007 VBA
Techncial Editor for Special Edition Using Microsoft Access 2007 and Access 2007 Forms, Reports & Queries From Que Publishing

Brooklyn College BA

©2016 All rights reserved.