Hello, all. Not quite sure if this is the proper category for the question, but here goes...
Long story short, we have ~10 to 12 users who are working from home and connect to the local network through a VPN (SonicWall router as the endpoint and the SonicWall VPN client on the remote users' computers). Our WAN connection is roughly 10Mbps/2Mbps. There are maybe 3 users with full versions of Access while everyone else has the Access 2010 Runtime installed.
What's happening is when they try to open the form(s), it's really slow. Like 8 - 20 seconds just to open, whereas on the local network it's around 1 to 5 seconds depending on the form (the forms do need a good deal of optimization, I know). They also occasionally run into an error where Access tells them it needs to rebuild the database and create a backup which takes time and causes some concern.
Our transition to Access is very new and the rollout has only been live for roughly a week, so I don't have a lot of specific feedback from the users, only the reports on the slow speed and the error->rebuild events. The slow speed really came as no surprise due to the slowdown that comes with a VPN. I don't know enough about SonicWall as a solution or if it's being pushed beyond what it's really capable of. I think it's also possible that the connection speed is playing a part. It may also be a matter of patience. Like, people thinking Access has crashed when it's really just slow to load, so kill the app before it's done doing what it was trying to do.
Any thoughts? Since I don't know how long we will be having these folks work from home due to the COVID-19 thing (could be 3 months, could be 6 months, I just don't know) I am reluctant to buy a better/more apt VPN appliance. Same goes for upping the connection speed. Do you think running a newer Access runtime would help? Say, Access 2019 Runtime?
At this point any suggestions would help.
Thank you!