A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Database Design
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Access 2007 MSACCESS.EXE consuming RAM



 
 
Thread Tools Display Modes
  #1  
Old February 4th, 2010, 06:51 AM posted to microsoft.public.access.tablesdbdesign
Steve
external usenet poster
 
Posts: 2,662
Default Access 2007 MSACCESS.EXE consuming RAM

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.

Regards,
--
Steve
 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 08:21 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.