How can I improve a network database's performance

[Guest]

Hello,

I have a database, which is on a network share drive. When people who are
fairly local access it, there are no problems. The problem is when people who
are across the country or overseas access the database, it is so slow it is
nearly worthless to use.

Can anyone recommend how make the database more efficient without using
replicas? Is there any other type of server or drive I should look into
utilizing?

thanks
bt

 

[Guest]

use Terminal Server or Remote Desktop

 

[M.L. Sco Scofield]

Take a look at http://www.granite.ab.ca/access/performancefaq.htm.

Good luck.

Sco

M.L. "Sco" Scofield, Microsoft Access MVP, MCSD, MCP, MSS, A+
Denver Area Access Users Group Communications Director www.DAAUG.org
MS Colorado Events Administrator www.MSColoradoEvents.com
Useful Metric Conversion #18 of 19: 8 nickels = 2 paradigms (My personal
favorite)
Miscellaneous Access and VB "stuff" at www.ScoBiz.com

 

[Tom Wickerath]

To add to dlv's suggestion, Access databases do not do well when run in WAN environments, as you
have discovered. Access MVP Albert Kallal has written a paper that you should read:

http://www.members.shaw.ca/AlbertKallal/Wan/Wans.html


Tom
________________________________


use Terminal Server or Remote Desktop
________________________________


Hello,

I have a database, which is on a network share drive. When people who are
fairly local access it, there are no problems. The problem is when people who
are across the country or overseas access the database, it is so slow it is
nearly worthless to use.

Can anyone recommend how make the database more efficient without using
replicas? Is there any other type of server or drive I should look into
utilizing?

thanks
bt

 

[Albert D. Kallal]

You can read about some solutions to this problem here:

http://www.members.shaw.ca/AlbertKallal//Wan/Wans.html