Async_Network_IO , how to avoid it if possible

DVP 2015-06-25 01:03:33

I see lot of ASYNC_NETWORK_IO waits on connections from MS Access database processing with SQL Servers.

What would be a way to reduce these waits from the server side if the Users are not willing to modify their Access Modules ?

Is it possible at all ?

Aaron Bertrand 2015-06-25 15:40:38
Take away their Access licenses? Sorry, I'm trying to be funny, but in reality I don't know that anyone here will have enough Access prowess to effectively address your question. You might want to give the Access for Developers MSDN Forum a try.