Results 1 to 7 of 7
  1. #1
    gicarto is offline Novice
    Windows 10 Access 2016
    Join Date
    Jul 2013
    Location
    Madison, Wisconsin
    Posts
    11

    Access will not update any data with two users using the same backend-Recordset not updatable

    Hello-



    I am having a very rough time trying to get my database application to allow multiple users. I have a backend JET database to store all of the table data and I have a front end to interact with it. There are only 5 users for the application so it shouldn't seem too hard (but it is). When someone else is using the backend database, I can't change any data while I am connected to the backend. When I open a form it says that the recordset is not updatable. I have gone through the application and I set all of the forms to "edited record" and made sure that the backend opens in share instead of exclusive. I don't know what else to try. The backend application is located on a local area network with the front ends stored on C drives. I have run the linked table manager and there are no issues. Is there a setting that I am missing?

    Thanks

  2. #2
    June7's Avatar
    June7 is online now VIP
    Windows 10 Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,815
    Only thing I can suggest is to examine record locking options in Client Settings of FE and BE.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  3. #3
    gicarto is offline Novice
    Windows 10 Access 2016
    Join Date
    Jul 2013
    Location
    Madison, Wisconsin
    Posts
    11
    Does this mean that access doesn't work for multiple users, despite saying it does?

  4. #4
    Join Date
    Jan 2017
    Location
    Swansea,South Wales,UK
    Posts
    4,858
    No, it works for multiple users.
    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

  5. #5
    Join Date
    Jun 2010
    Location
    Belgium
    Posts
    1,035
    It works for multiple users, but you have some options you can set yourself. For instance : open the property sheet of a form and look at the tab data. The bottom property is Record locks.
    Default setting = no locks, but you can set it to All records, which means that once a user opens the dataset and starts changing one of the records, the whole recordset is locked for all other users. There is also the setting Edited record which only locks the one page with the record that is changed. Notice that, while the description says it only changes 1 record, the minimum locked quantity is a page. So if there are 3 records on that page, all 3 are locked.

  6. #6
    gicarto is offline Novice
    Windows 10 Access 2016
    Join Date
    Jul 2013
    Location
    Madison, Wisconsin
    Posts
    11
    Maybe I should be using legacy encryption instead of the default encryption. The application was set to default.

  7. #7
    June7's Avatar
    June7 is online now VIP
    Windows 10 Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,815
    Set where? I have never done anything with encryption.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

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

Similar Threads

  1. Creating an updatable query recordset using Access 2010
    By Bill McCoy in forum Programming
    Replies: 1
    Last Post: 04-17-2012, 09:36 AM
  2. Why does this recordset become not-updatable
    By bginhb in forum Programming
    Replies: 3
    Last Post: 08-24-2011, 05:29 PM
  3. Recordset not updatable...WHY?
    By jgelpi16 in forum Queries
    Replies: 3
    Last Post: 11-30-2010, 08:40 AM
  4. Recordset not updatable
    By Ogian in forum Forms
    Replies: 3
    Last Post: 10-20-2010, 12:08 AM
  5. The Recordset is not updatable
    By bullet_proof302 in forum Access
    Replies: 2
    Last Post: 11-07-2009, 12:13 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