I've found various questions about Access speed over a remote connection but can't find one that quite covers this problem.
Apologies if I've missed it.
Until two weeks ago, we had a load of databases on a shared drive (P:\). They were set up with a shared back end and each user having their own front end.
The P drive is used throughout the company, for a lot of things.
With the whole Covid 19 thing, all users have been working remotely.
The connection speed was fairly slow, so I was able to get our IT support to build a new, dedicated server (Q:\) to host just our databases. I moved all Access front and back ends over and remapped where required, but now the connection speeds are slow to the point of being unusable at times if accessing the databases from outside the company.
I'm hoping someone whose gone through a similar move might have experienced something along these lines and have some words of wisdom about what might be causing the drop in speed?
Thus far:
* IT can't find any network speed difference between the two machines. Not sure how they measure this but they did.
* If using a PC from within the building, the speed is much faster than using the old server within the building, which suggests to me that the drop when accessing remotely may be VPN related but doesn't explain the big drop between the old and new servers
Apologies if I've missed it.
Until two weeks ago, we had a load of databases on a shared drive (P:\). They were set up with a shared back end and each user having their own front end.
The P drive is used throughout the company, for a lot of things.
With the whole Covid 19 thing, all users have been working remotely.
The connection speed was fairly slow, so I was able to get our IT support to build a new, dedicated server (Q:\) to host just our databases. I moved all Access front and back ends over and remapped where required, but now the connection speeds are slow to the point of being unusable at times if accessing the databases from outside the company.
I'm hoping someone whose gone through a similar move might have experienced something along these lines and have some words of wisdom about what might be causing the drop in speed?
Thus far:
* IT can't find any network speed difference between the two machines. Not sure how they measure this but they did.
* If using a PC from within the building, the speed is much faster than using the old server within the building, which suggests to me that the drop when accessing remotely may be VPN related but doesn't explain the big drop between the old and new servers