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.