Report and Forms in Access ADP timeout

[Waterman]

I'm experiencing an intermittent problem in my Access ADP where report and
form requests seems to timeout. I have never experienced on my computer, but
I have witnessed it at my users' workstations. The network admin says he can
see the request hit the SQL Server, but says it's the client (my ADP) that's
timing out. The reports and forms themselved aren't large, and usually only
take a second or less to run. Any suggestions on what could be causing this?

 

[Mary Chipman]

One of the best tools to troubleshoot this kind of issue is SQL
Profiler. Work with your dba to create a trace and see if you can
repro the situation and figure out what's going on between your ADP
and SQL Server to cause the lack of response on the server that causes
your app to timeout.

--Mary