Results 1 to 4 of 4
  1. #1
    mond007's Avatar
    mond007 is offline Advanced Beginner
    Windows 7 Access 2007
    Join Date
    May 2010
    Posts
    52

    Access not alowing multi user. You do not have exclusive access to the database

    Hi


    I have designed and written an MS Access solution where I thought I would have all users being allowed to access the database at the same time.
    However, the second user is getting the following message :

    "You do not have exclusive access to the database, if you proceed to make changes, you may not be able to save them later."

    The design is as follows :
    Click image for larger version. 

Name:	Starter_Leaver_Table_Layout.jpg 
Views:	17 
Size:	162.3 KB 
ID:	25954

    So I have 5 separate forms.

    1) This form adds the core main record in Tbl_Starter_Leaver
    2) A form to insert Tbl_RADS data i.e. Tbl_Stater_Leaver v Tbl_RADS
    3) A form to insert Tbl_Boarding data i.e. Tbl_Stater_Leaver v Tbl_Boarding_Status
    4) A form to insert Tbl_IT_Status data i.e. Tbl_Stater_Leaver v Tbl_IT_Status
    5) A form to insert Tbl_SAP data i.e. Tbl_Stater_Leaver v Tbl_SAP

    an example of no 2 above follows :
    Click image for larger version. 

Name:	Stater_Leaver v RADS.jpg 
Views:	15 
Size:	80.3 KB 
ID:	25955

    I imagined I would not have problems with multi users entering data but as you can see I am getting error for subsequent users :

    "You do not have exclusive access to the database, if you proceed to make changes, you may not be able to save them later."

    Any advise would be appreciated, as I am thinking this might be a setting somewhere. I am also about to link an Excel Workbook to it and extract data from it.

    Thanks in advance.

  2. #2
    CJ_London is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    11,397
    the message implies users are trying to change forms or reports - either themselves or you have code that does that. Alternatively, users are trying to open the db in exclusive mode. Depends when you see the message

    This can often come about if users are sharing the front end. Each user should have their own front end stored locally and data stored in a mutually convenient back end on the network

  3. #3
    mond007's Avatar
    mond007 is offline Advanced Beginner
    Windows 7 Access 2007
    Join Date
    May 2010
    Posts
    52
    Oh ok so this means I have to split the database.

    I have looked into this :

    Splitting Starter Leaver MS Access DB into Front End & Back End considerations
    https://www.accessforums.net/showthr...210#post325210

    You are right I will spilt the database and store the backend in central location and the front end should be copied to each user machine using the solution in my above link.

    I will have a go. Thanks

  4. #4
    CJ_London is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    11,397
    yes - any multi user database should be split, otherwise among other things there is a risk of corruption and it is impossible to maintain whilst users are in the database

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

Similar Threads

  1. Import Access Database into Excel in Multi-User Environment
    By Chim20 in forum Import/Export Data
    Replies: 7
    Last Post: 10-06-2016, 02:23 PM
  2. Replies: 4
    Last Post: 03-31-2015, 01:20 PM
  3. Multi-User Access Open Database problem
    By RayMilhon in forum Access
    Replies: 1
    Last Post: 09-25-2012, 04:23 PM
  4. Replies: 3
    Last Post: 07-23-2012, 11:46 AM
  5. Can Access become a multi-user database?
    By DPCarusone in forum Access
    Replies: 3
    Last Post: 02-10-2012, 12:26 PM

Tags for this Thread

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