Wednesday, December 8, 2010


Problem Sharing Access Database (MDB) By Multiple Users

When you have Access databases that are configured for multiple user access, you might have come across a problem that only the first user to connect can access the database - all later access will be blocked.

If you have such problem, make sure all those who have access to the database file have full right on that file. That is, can they able to change the database?

In theory, the path to the databases always remains the same, so Access should not have an issue handling multiple users, but share does appear to be causing some issue here. This fairly clearly indicates that the issue is an Access problem with share, not share directory or the domain server.

When multiple users try to use Windows Explorer or a shortcut to open a Microsoft Access database that has already been opened by a user, the users experience one of the following symptoms:
  • Nothing occurs.
  • An hourglass appears for several seconds, and then nothing occurs.
To work around this problem, use one of the following methods.
  • Method 1: Modify the shortcut, In the target of the shortcut, include the path of MSAccess.exe.
  • Method 2: Open the database in Access
Follow these steps:
1. Start Microsoft Access.
2. Open the database.


About bench3 -

Haja Peer Mohamed H, Software Engineer by profession, Author, Founder and CEO of "bench3" you can connect with me on Twitter , Facebook and also onGoogle+

Subscribe to this Blog via Email :