SQL Server Latency returning results using MS Access front end/SQL backend.

PSERS BIT used Ask the Experts™
I set up a MS Access front end with an ODBC to a MS SQL Server database.  When I do a search via an access form, it is taking over 2 minutes to return the result.  I'm not sure what is causing the latency.  I configured the ODBC to use the server ip address + MSSQLSERVER,Port #.  I experienced the same amount of latency using port 1433 and 1434.  Any suggestions as to how to resolve the latency would be greatly appreciated.
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
is your fe 32bit? and did you use the 32bit odbc utility?


I'm using a 32 bit odbc - odbcad32

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial