Access 2007 MSACCESS.EXE consuming RAM


S

Steve

Hi,

My firm has a system developed in Microsoft Access 2003 that is deployed as
..MDE's by opening and saving using Microsoft Access 2007. The system is
connected to an SQL Server 2005 Database using ODBC.

The Microsoft Access 2007 system is deployed on a Windows 2008 R2 64 Bit
Application Server and connects to the SQL Server 2005 database on a Database
Server. Multiple users connect to the Microsoft Access 2007 system front end
using Terminal Server.

Our problem is that the MSACCESS.EXE*32's are continuosly growing in size as
the system is used. For example if a user simply opens and closes a form then
the MSACCESS.EXE*32 will continue to increase in memory usage as long as the
user keeps doing this. Memory (Private Working Set) in Task Manager continues
to grow as does Commit Size. We have users where the MSACCESS.EXE*32 is
getting up to 300+ Mb in memory usage.

Would you please assist. What should we start looking at? Is there a Memory
limit that may be set for each instance of the MSACCESS.EXE*32? Is there a
Memory Management facility on the Windows 2008 Server? Is the problem
associated with Jet?

Thanks in advance for any assistance.

NB:- I also posted this in Database Design but General Questions is probably
more appropriate.

Regards,
 
Ad

Advertisements

T

Tom van Stiphout

On Wed, 3 Feb 2010 22:10:01 -0800, Steve

You didn't say if this actually causes any problems.

I can't repeat your findings with the Northwind sample application.
Can you try that one?

It is possible the memory will gladly be released when memory pressure
occurs.
Does the machine have all latest service packs installed? No use
chasing a problem that is already fixed.

-Tom.
Microsoft Access MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top