Remote Access speed issue

C

Cindy K

I have an Access database executable that runs on an off-site computer
connected to my server via vpn. Alls well with the connections but it is VERY
slow. I know this is one of the downsides to using Access but does anyone
have a solution to this? Would using an sql database back end speed this up
to real time as if in the office?

Thanks
 
R

Rick Brandt

Cindy said:
I have an Access database executable that runs on an off-site computer
connected to my server via vpn. Alls well with the connections but it
is VERY slow. I know this is one of the downsides to using Access but
does anyone have a solution to this? Would using an sql database back
end speed this up to real time as if in the office?

Thanks
Click to expand...

If you are using the VPN to gain access to the remote network and are then
running the app with a copy of Access on your local PC, then you're right.
That will be a terribly slow way to go and it runs a high risk of corrupting
the file.

Instead you could set up a Terminal Server at the remote location and run
the Access app remotely from your location on that server. Then all of the
Access processing and i/o stays on the remote LAN and the only thing that
goes over the VPN is the screen updates and keyboard/mouse inputs. In most
cases a setup like this is virtually indistinguishable from running the app
on the LAN itself.
 
Top