John Colby
jwcolby at ColbyConsulting.com
Thu Apr 13 21:14:26 CDT 2006
I have just discovered that the following code causes a memory leak: Function TestFWMemLeak() While 1 DoEvents FWInit CurrentProject.Connection Wend End Function Public Function FWInit(lCodeProjConn As ADODB.Connection) End Function Open task manager and keep it on top. Find MSAccess and watch the memory usage. As you run TestFWMemLeak the memory usage climbs steadily. When I google "memory leak ADODB.Connection" I get a ton of hits, though not this specific issue. John W. Colby www.ColbyConsulting.com