A2010 program not releasing resources.

I have a 14MB .ADP application with a SQL Server 2005 backend. When run in A2010, the program (viewed in the task manager) opens in 47.6MB and grows by 20MB each time an "update contact information" screen is opened. The program size decreases about 1MB when the screen is closed (doing nothing but opening and closing the screen) but grows another ~20MB when that same screen is opened again. After 4 open/closes, the program size is 110MB and growing.
When I run exactly the same app with the same back end in A2003, the program grows a bit but only by ~2MB each time. Under A2003, the app starts at 36.5MB and after the same series of operations as above, it's size is 44.4MB. So it is growing a bit with each operation but much more slowly.
All the objects are released in the code that is being executed.
Has anyone run into this issue in A2010?
modleAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Jeffrey CoachmanMIS LiasonCommented:
Notes that ADP's were deprecated in Access 2007.
They will still run in Access 2007 and 2010, but God only knows what the performance ramifications might be (issues like what you are experiencing)

Can you post any code behind the opening of the "update contact information" screen?

Perhaps there is a fix for this, ..but it may just be "the way it is".

They only suggestion I can make is that unless you can point to a specific "Issue" that this bloating causes, then just make sure you do a Compact & Repair on a regular basis.

Let's see what the other Experts contribute...


JeffCoachman
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
modleAuthor Commented:
The "issue" is that if a data entry person has (for example) 40 people to update, the program grows to 1GB about halfway through the stack of updates and the pc runs out of resources (message from ms/Access or from Win7 - don't know which). If you then exit and restart the app, it's back to its original size and performs fine until then next encounter with a 1GB size.

Are you suggesting C&R while it's running? I've never done that.....only done that on exit or in development.
0
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database Architect / Systems AnalystCommented:
"Are you suggesting C&R while it's running? I've never done that..."
No ... he means when not open ... but clearly, your issue exceeds that.

Allen keeps the bug list pretty much up to date ...

http://www.allenbrowne.com/Access2007.html

but I would not be hopeful for a fix anytime soon.  Do you have O2010 SP1 installed ?

mx
0
10 Tips to Protect Your Business from Ransomware

Did you know that ransomware is the most widespread, destructive malware in the world today? It accounts for 39% of all security breaches, with ransomware gangsters projected to make $11.5B in profits from online extortion by 2019.

Jeffrey CoachmanMIS LiasonCommented:
<The "issue" is that if a data entry person has (for example) 40 people to update, the program grows to 1GB about halfway through the stack of updates>
LOL!
Then I guess that really is an "Issue"
;-)

Just to be clear,
My point was just that some people will notice 1mb bloat in a 10MB db, and think that it is an issue.
Not realizing that the DB will always bloat to a certain extent, as just a function of how an Access db works.
In other words, I was in no way trying to trivialize your issue here.
:-)


But yes, the DB bloating to 1GB is certainly something to be concerned about.
Not only to disk performance, but that this is half of the Max DB size allowable in MS Access...

No, you can't automate Compacting the DB while it is open
(You can do it manually, but that will probably become a pain)


My guess is that you will have to take a close look at what is happening when you open the "update contact information" screen.
(In other words, try reducing the number of Updates done at any one time, perhaps, ...if this is possible?)

Note that releasing objects (and setting them to Nothing) will release the *memory*, not necessarily reduce the bloat (hence the need for a dedicated C&R utility)

JeffCoachman
0
Jeffrey CoachmanMIS LiasonCommented:
But check you SP first as MX suggested, sometimes issue like this are addressed there.
0
modleAuthor Commented:
I will check with our IT about SP1. However, I believe I read what was "fixed" in SP1 and there was nothing about Access. Maybe I read the wrong document......

The solution has been.....that the user exits and reenters the app and continues. It's just a bit of a pain. PS: there are about 15 users at a time in this app. Only when someone is doing extensive data entry on multiple records (75K in the db all together) does the size creep interfere with usage.

Thanks for your help.
0
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database Architect / Systems AnalystCommented:
"Maybe I read the wrong document......"
I have seen docs showing what was fixed.  However, certainly not a complete list.  

mx
0
Jeffrey CoachmanMIS LiasonCommented:
<Only when someone is doing extensive data entry on multiple records (75K in the db all together)>
So you still may want to investigate ways to limit the updates, ...then perhaps the bloat might be "tolerable"?

Jeff
0
modleAuthor Commented:
I made sure Office 2010 SP1 was installed and tested again. No change - memory increases in 20MB chunks and never releases.
0
Jeffrey CoachmanMIS LiasonCommented:
OK, sorry I could not help more...
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.