Results 1 to 8 of 8
  1. #1
    tcg is offline Novice
    Windows 10 Office 365
    Join Date
    Dec 2021
    Posts
    4

    One User Not Getting Access to Data


    We have 5 people sharing an Access application. The database is split; the backend file is on a central server, and each user has a copy of the frontend file on their machine. The application runs a query on load and populates the forms on the page with data. However, one of our users does not get this data...just a blank form. This problem is only fixed if they are the first user to access the program, in which case it locks everybody else out. So essentially, she can get in if nobody else is and locks everybody else out, and she cannot get access to the data if anybody else is in. The user's settings are set on "Shared" mode.

  2. #2
    tcg is offline Novice
    Windows 10 Office 365
    Join Date
    Dec 2021
    Posts
    4
    Also, even if the front-end file on the server is copied and pasted onto their machine we still run into the same issue. I'm not sure if there is a setting of some sort on the machine causing this.

  3. #3
    Join Date
    Jan 2017
    Location
    Swansea,South Wales,UK
    Posts
    6,283
    Well to me that would infer she is trying to access the BE exclusively?, but that is as much as I can offer, sorry.
    Google how to open exclusively and take it from there?
    Please use # icon on toolbar when posting code snippets.
    Cross Posting: https://www.excelguru.ca/content.php?184
    Debugging Access: https://www.youtube.com/results?sear...bug+access+vba

  4. #4
    tcg is offline Novice
    Windows 10 Office 365
    Join Date
    Dec 2021
    Posts
    4
    Thank you, I'm just confused as to why it is operating like she has exclusive rights when it is in Share mode.

  5. #5
    Join Date
    Jan 2017
    Location
    Swansea,South Wales,UK
    Posts
    6,283
    Well, as it is only her, I'd hazard a guess it is something to do with her PC.?
    If she uses another PC, does it still happen?

    https://www.google.com/search?q=access+setting+for+open+exclusive&ie=utf-8&oe=utf-8

    All options appear to have to be selected as exclusive?
    Please use # icon on toolbar when posting code snippets.
    Cross Posting: https://www.excelguru.ca/content.php?184
    Debugging Access: https://www.youtube.com/results?sear...bug+access+vba

  6. #6
    tcg is offline Novice
    Windows 10 Office 365
    Join Date
    Dec 2021
    Posts
    4
    We are pretty sure it's related to this: https://www.devhut.net/access-lock-file-issues/ . I appreciate your help.

  7. #7
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,643
    Post 6 was moderated, I'm posting to trigger email notifications.
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

  8. #8
    Join Date
    Jan 2017
    Location
    Swansea,South Wales,UK
    Posts
    6,283
    Please use # icon on toolbar when posting code snippets.
    Cross Posting: https://www.excelguru.ca/content.php?184
    Debugging Access: https://www.youtube.com/results?sear...bug+access+vba

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

Similar Threads

  1. Replies: 2
    Last Post: 06-10-2020, 10:23 AM
  2. Replies: 1
    Last Post: 05-29-2019, 10:54 AM
  3. Help a new Access user summarize data
    By afabris in forum Queries
    Replies: 3
    Last Post: 11-01-2013, 01:56 PM
  4. Replies: 4
    Last Post: 12-16-2010, 05:29 AM
  5. Replies: 2
    Last Post: 04-22-2010, 10:40 AM

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