Results 1 to 3 of 3
  1. #1
    Mercer999 is offline Novice
    Windows 10 Access 2016
    Join Date
    Jul 2019
    Posts
    11

    Form Structure for Multi User Environment


    If creating an Access Database front end with SQL Server back end for, say, 20 people to use at one time, what is the best way to setup forms and tables to avoid records being lock due to more than one person trying to access at the same time? Is it good to have a table on the front end client side to hold form data which is submitted to the record table in batches? Thanks.

  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,815
    As long as they don't edit same record at same time, shouldn't be a problem.

    Each user should run their own copy of frontend installed on their computer.

    Don't think a temp table in frontend should be needed.
    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
    orange's Avatar
    orange is offline Moderator
    Windows 10 Access 2010 32bit
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,716
    As June points out there shouldn't be an issue unless several people are trying to edit the same record at the same time.
    Depending on the data involved and the application, there may be some scheduling techniques to reduce same record conflicts.
    For example, if the application involves responding to clients, you could assign people to records based on Location or Date or Client Name etc. Joe deals with Clients in Western States/ Suzette deals with clients in Southern States; or Jim handles clients whose requests were on odd numbered day and AM; or some pattern that is simple and allows separation of workloads.

    I don't think a separate table in the FE would be needed. But we have no idea of what your proposed application entails.
    Good luck with your project.

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

Similar Threads

  1. Access not opening in a multi user environment
    By Lakecanters in forum Security
    Replies: 4
    Last Post: 01-24-2018, 06:16 PM
  2. Split DB Question - Multi User Environment Launch
    By aussie92 in forum Database Design
    Replies: 6
    Last Post: 01-22-2014, 03:19 PM
  3. Replies: 3
    Last Post: 06-14-2012, 08:10 AM
  4. Record Locking Multi User Environment
    By praetorianprefect in forum Database Design
    Replies: 5
    Last Post: 04-16-2012, 02:31 PM
  5. Replies: 13
    Last Post: 05-18-2010, 01:12 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