memory monitor

[Florin]

Hi all,
My access application uses some self-built classes to create a portal kind
of experience.
For some reason the memory goes through the roof.
I've identified one possible reason in the way Access deals with png images
(blocking 50 kb of memory for each tiny png <1kb).
I've replace the pngs with gifs which solved partially the issue.
But still the memory used is way too high.
I'm trying to monitor the used memory during various tests and various
stages of the tests.
I've been using Performance Monitor so far but I find the logging
inconvenient.
Do you know of a tool out there that can help me track the memory usage in a
dynamic way more tailored to Access?
I'm using MS Access 2007 with an mdb front-end linked to an SQL Server 2008
database.

Thanks for any help!

 

[Jeff Boyce]

Florin

By "memory" do you mean the RAM? If so, how are you currently determining
that the "memory usage goes through the roof"?

Are other applications you have open simultaneously dragging to a halt? Are
you using a PerfMon that tells you Access is consuming all of the PC's RAM?

Or are you talking about the size of the Access .mdb/.accdb file into which
you are placing images? If this, which version of Access are you using?

More info, please...

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Florin]

Hi Jeff, thanks for your reply.

By memory I mean RAM, yes. Always a good question .
And I've used Performance Monitor and analyzed the memory taken only by the
msaccess.exe. Since my application is quite a complex front-end for a SQL
Server backend, in order to find out where the memory increases I had to
manually put stops in the code and went back and forward between access and
profmon.
What I'm looking for is a more convenient tool or process for this.

FYI, it doesn't get to the point where the other applications are affected,
but it gets to the point where Access stops working, pretty much when the
memory reaches about 200 MB.

Any ideas?
Thanks again!

 

[Jeff Boyce]

Florin

I haven't noticed a slow-down in Access front-ends. Is there a chance the
PC has multiple applications all open and running simultaneously?

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Florin]

Hi Jeff,
No, I'm running Perfmon on that specific process. And it's not about slowing
down, it's about crashing. Once the memory used by msacess.exe gets close to
200 MB it simply stops responding properly until I close a form or something.
I hope this makes sense.
Thanks!
Florin

 

[Jeff Boyce]

Sorry, I haven't seen this kind of behavior.

Have you tried searching on-line, using your favorite search engine?

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Gina Whipp]

Florin,

Thought... are you running an Antivirus? If yes, I would suggest turning it
off and seeing what happens.

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

 

[Florin]

Hi Jeff,

I dug some more and it looks like Access is simply using too much virtual
memory, at least 10 MB for each form or subform it opens. This together with
a lot of memory used for images generates a bloating of the virtual memory
over 2 gb which makes Access throw the "not enough memory" error.

Please check my other recent post in this forum called "maximum number of
open forms...". In it there's also a link to my blog which has a test
database you can use to replicate this behavior.

Thanks again for your help!
Florin