Just an FYI, MS does not believe this is an MS Access or SQL problem. They haven't determined the exact issue and are still working on it.

I thought about that also but I don't know where the impersonation would have been set up at. The SQL server is dedicated to SQL and does not have any...

The application MS Access. The DSN is a system DSN. The security is NT Authentication. When I see the user in the activity monitor, their login shows as the system...

Is this SQL 2000?

Maybe this link will help

http://support.microsoft.com/default.aspx?scid=kb;en-us;308795

We also had the same problem as DanaH1976 with a sql server 7.0 sp3 running on advanced server 2000 sp2 not releasing memory and locking up the machine. It didn't...