I know that a lot depends on network capacity and server strength but is it typically faster to leave the front ends on the server or workstation?
I've always kept my front ends on the workstations with the back ends on the server but my biggest performance issue right now with my access apps seems to be the network.
All tables are in the back ends
Everything else is in the front end, forms, queries, macros, reports...
I have 2 now aging dell poweredge 4200 servers, a 1 mbps network and apps that have 2-5 concurrent users.
Thank you kindly