I am using VBA scripts to query SQL and each time i run
the query the memory assoc with sqlsvr.exe increases and
does not release.
Dim wksp As DAO.Workspace, conn As DAO.Connection, rst As
DAO.Recordset, fld As DAO.Field

strConnect = "ODBC;DSN="
& "InSQL;UID=wwAdmin;PWD=wwAdmin;Database=Runtim e"
Set wksp = DBEngine.CreateWorkspace
(Server, "wwAdmin", "wwAdmin", dbUseODBC)
Set conn = wksp.OpenDatabase(Server, dbDriverNoPrompt,
True, strConnect)