ODBC Connection Pooling Latency

[Steve Sawyer]

When I change a SQL server address using the ODBC
connection manager, my Access application continues to
connect to the old server address. I've disabled
connection pooling to no avail...

I need to move SQL server from one physical location to
another and had hoped changing the ODBC DSN configuration
for about 150 users would suffice.

Anyone have ideas?

 

[gandalf]

things to check:

relink linked tables (as the old dsn might be stored there)
check you code (references to ip's)