I've just upgraded my network and am still noticing MSAccess going into "not responding" status when i run my queries.
When i check the Ethernet status on my workstation i can see the non responding status corresponds with the RECEIVE size of the graph exceeding 100 kbps.
Am i correct in suspecting the request to the backend tables is returning a result that is maxing out the capacity of our network to send the required data back to the workstation? If so what is the maximum data MSAccess can reasonably return without going into "not responding" status?
I'm not sure how to go about making the queries more efficient as the data returning back is what is required (no other data coming back along with the required data for instance).
Any ideas on how to fix this problem is greatly appreciated.
thanks,