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.