speeding up performance on a wan network

[madrav72]

hi all

i have a access application which is split into 2 bits with the backend being on the network

the thing is its very slow performance wise and i want to try and optimise it better if possible

any ideas???

thank you

 

[FoFa]

Run it on Citrix/Terminal Server
Put the BE in SQL and run the heavy duty data crunching on the server (stored procedures etc.)
Limit the rows returned on everything (usually not practical)
Put something like a WEB (asp) front end on it instead

Any thing else to limit the amount data that goes across the network.

 

[Oldsoftboss]

Have a quiet read here:

http://www.microsoft.com/office/previous/xp/columns/column05.asp

http://www.access-programmers.co.uk/forums/showthread.php?t=85461

http://support.microsoft.com/default.aspx?scid=kb;en-us;889588