Release memory on SQL Server

[Anthony Smith]

Good Morning Everyone,

I'm running an Access XP application on the front end and a SQL Server 2000
on the backend.
Can anyone tell me the proper way to CLOSE my Access application so that it
will release any memory it took from the server. Almost every day, my server
runs down to about 10-15% of the memory, and I believe SQL is the problem. I
set the max usage on the memory but it still doesn't matter. Does anyone
have any code that I can put in my Access Application when a user quits the
program, it will close things up on the server? Thanks!

Anthony Smith

In God We Trust!

 

[Vadim Rapp]

AS> I'm running an Access XP application on the front
AS> end and a SQL Server 2000 on the backend.
AS> Can anyone tell me the proper way to CLOSE my
AS> Access application so that it will release any
AS> memory it took from the server. Almost every day,
AS> my server runs down to about 10-15% of the memory,
AS> and I believe SQL is the problem. I set the max
AS> usage on the memory but it still doesn't matter.
AS> Does anyone have any code that I can put in my
AS> Access Application when a user quits the program,
AS> it will close things up on the server? Thanks!

apply all service packs to Office, to MDAC (www.microsoft.com/data), and to
SQL Server.

Vadim