Results 1 to 2 of 2
  1. #1
    RogerD is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Dec 2014
    Location
    Ky
    Posts
    27

    Message when opening access "You do not have exclusive access to the database at this time"

    We have been using an Access dB for MRP that was built 15 or more years ago. I rebuilt the database to optimize/update macros, reports, etc. It works great.
    Typically, we will have up to 5 users in the database throughout the day. with the old database, the only time you would receive a message about exclusive access would be if you were trying to change a report, query, table or macro. With the new database, anytime a second user opens the database, the message "you do not have exclusive access to the database at this time. If you proceed to make changes, you may not be able to save them later."
    This is not a show stopper, but an aggravation I would like to resolve.



    Any suggestions appreciated.

  2. #2
    JoeM is offline VIP
    Windows 7 32bit Access 2007
    Join Date
    Jun 2012
    Posts
    3,904
    Whenever you have multiple users using the same database, you should always "split" the database.
    In a "split" database, there is one common back-end database, which holds all your data.
    Then, each individual should have their own copy of the front-end, which has everything else (Queries, Forms, Reports, VBA, etc). And they use their own copy of the front-end to access the database.
    In the front-end, the tables are linked to the the back-end database.

    Splitting the database eliminates the issues you discuss, greatly cuts down the chances of corruption, and makes rolling out new versions easier (don't have to worry about kicking users out).

    There are many articles on splitting an Access database that you can locate with a simple Google search. Here is one:
    https://support.office.com/en-us/art...3-51b1d73498cc

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 4
    Last Post: 05-28-2015, 01:51 PM
  2. Replies: 13
    Last Post: 09-03-2014, 03:49 AM
  3. Replies: 1
    Last Post: 03-11-2014, 08:07 PM
  4. Replies: 1
    Last Post: 04-21-2013, 06:13 PM
  5. Replies: 7
    Last Post: 06-28-2012, 02:05 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums