Slow Processing over Network

[weasel7711]

We have a small business server (SBS2008) on a local network which is hosting our database back end. All of the client computers have a front end (Mix of Windows XP and 7) locally. When connecting to the database through the network the execute time for a query increases dramatically. When the front end is tested locally (copied and linked) the queries can run in less than 1 second. When they are connected to via the network the queries/reports take at least 55 seconds, sometimes longer on the same client machine. What can be done to improve performance?

[ajetrumpet]

not sure, but 55 seconds is not very long, actually.

I've always had issues with fe/be environments with access. It just has always been slow. last conn. I had with a mysql 5.1 driver took the stupid thing 1 min or more to connect via vba scripts.

[RuralGuy]

Here's the link I recommend for performance issues: http://www.granite.ab.ca/access/performancefaq.htm