Results 1 to 6 of 6
  1. #1
    googalabosh is offline Advanced Beginner
    Windows 10 Access 2016
    Join Date
    Sep 2017
    Posts
    45

    2 users accessing 1 database


    Set up:
    I have a front end with the forms and queries and a separate back end with the tables. Each user will have their own copy of the front end and will link it to the back end.

    Questions: Can two users be accessing the back end at the same time? If so, can two users access the same record at the same time? If so, how does this work (i.e. can users see the changes live, which one overrides the other, etc.)?

  2. #2
    isladogs's Avatar
    isladogs is offline Very idle programmer
    Windows 10 Access 2010 32bit
    Join Date
    Jan 2014
    Location
    Somerset, UK
    Posts
    4,069
    If each user has their own copy of the FE then both can safely use it at the same time.
    There are various methods of locking records to prevent issues when 2 users try to edit the same record simultaneously.
    However, the principle is that the first user to access the record will be able to edit it but it will then be locked to other users
    Colin (Mendip Data Systems) : Website, email
    If this has helped, please click the star button and leave a comment

  3. #3
    googalabosh is offline Advanced Beginner
    Windows 10 Access 2016
    Join Date
    Sep 2017
    Posts
    45
    Quote Originally Posted by isladogs View Post
    If each user has their own copy of the FE then both can safely use it at the same time.
    There are various methods of locking records to prevent issues when 2 users try to edit the same record simultaneously.
    However, the principle is that the first user to access the record will be able to edit it but it will then be locked to other users
    By "locked", do you mean they will be viewing in "Read Only" essentially?

  4. #4
    isladogs's Avatar
    isladogs is offline Very idle programmer
    Windows 10 Access 2010 32bit
    Join Date
    Jan 2014
    Location
    Somerset, UK
    Posts
    4,069
    Either read only access or possibly not be able to open the record at all.
    Suggest you research the different methods of locking records
    Colin (Mendip Data Systems) : Website, email
    If this has helped, please click the star button and leave a comment

  5. #5
    googalabosh is offline Advanced Beginner
    Windows 10 Access 2016
    Join Date
    Sep 2017
    Posts
    45
    Quote Originally Posted by isladogs View Post
    Either read only access or possibly not be able to open the record at all.
    Suggest you research the different methods of locking records
    Will do! Thank you so much!

  6. #6
    Micron is offline Virtually Inert Person
    Windows 10 Access 2016
    Join Date
    Jun 2014
    Location
    Ontario, Canada
    Posts
    6,856
    Not read only in the typical sense IMHO. In some cases they will be able to begin an edit but will only find out that it is locked when they try to save.
    - "doesn't work" doesn't help. Implement changes in copies of your database.
    "Everyone has a photographic memory; some just don't have film." Steven Wright

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

Similar Threads

  1. Replies: 13
    Last Post: 12-28-2016, 11:39 AM
  2. Replies: 10
    Last Post: 03-29-2016, 12:20 PM
  3. Replies: 7
    Last Post: 09-19-2014, 03:58 PM
  4. Two different users accessing Access database
    By ultimateguy in forum Access
    Replies: 3
    Last Post: 06-25-2014, 03:43 PM
  5. Multiple users accessing same database
    By 4ACE in forum Access
    Replies: 0
    Last Post: 02-28-2008, 03:10 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
  •  
Tech Forums: Microsoft Office Forums