Access runs slow across network

[Ronni]

I have a Access 2003 database that I designed a while ago before I
knew that I would be sharing it via a VPN network with two locations.
My forms do a lot of checking and thus querrying data for verification
of entry.

It runs very fast on a local computer but when using via the two
offices it is very slow on the remote location. Asside from
rewritting the entire DB are there any other options/settings I could
use to get this running faster?

Thank you.

 

[Tom Wickerath]

Hi Ronni,

You might want to look into using Terminal Server. More information here, in
an article written by Access MVP Albert Kallal:

Using a wan with ms-access? How fast, how far?
http://www.members.shaw.ca/AlbertKallal/Wan/Wans.html

Also, you might want to check out my Multiuser Applications paper, to make
sure you did not miss any opportunities to improve performance:

Implementing a Successful Multiuser Access/JET Application
http://www.accessmvp.com/TWickerath/articles/multiuser.htm

Good Luck.


Tom Wickerath
Microsoft Access MVP
http://www.accessmvp.com/TWickerath/
http://www.access.qbuilt.com/html/expert_contributors.html
__________________________________________