Results 1 to 4 of 4
  1. #1
    erjohnson1 is offline Novice
    Windows 7 64bit Access 2013 32bit
    Join Date
    Aug 2016
    Posts
    3

    Split database slows to a crawl when >1 user


    I have a split database with each user having their own copy of the front end, and the backend hosted on a network folder. On startup, I open a hidden linked form to the backend to maintain a consistent connection and also open a switchboard for the user to interact with. When there is only one user, this switchboard loads in about 5 seconds from when you double click on access. When >1 one users it takes about 30 and it's not a linear time increase, as it's the same speed when it's 2 users or 10 users.

    I've tried tons of stuff from a bunch of different websites to speed up the loading times, but none of them have had any effect. The only thing that I can think of is that there is something with the locking file of the backend that is bottlenecking it. Anybody have any ideas? Record locking is also set to optimistic.

  2. #2
    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

  3. #3
    erjohnson1 is offline Novice
    Windows 7 64bit Access 2013 32bit
    Join Date
    Aug 2016
    Posts
    3
    Quote Originally Posted by orange View Post
    That's an entirely different website. What is your point?

  4. #4
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,518
    Here's orange's point:

    cross posters
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

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

Similar Threads

  1. Replies: 4
    Last Post: 11-23-2015, 06:21 PM
  2. Split / Database Security vs User Access
    By msaccess2&beyond in forum Database Design
    Replies: 7
    Last Post: 05-27-2014, 12:24 PM
  3. Multiple User - Split Database
    By ivpush33 in forum Access
    Replies: 2
    Last Post: 03-24-2013, 11:30 AM
  4. Split Form Slows Database
    By buienxg in forum Access
    Replies: 2
    Last Post: 11-26-2011, 10:20 AM
  5. Split Database only allowing single user access
    By terricritch in forum Database Design
    Replies: 2
    Last Post: 11-08-2011, 11: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