Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

memory leakage

memory leakage

memory leakage

Hi, I am running into a memory issue. Never had the problem on ACCESS 2000, under VISTA. Now running on ACCESS 2007 and windows 10.
Code is fairly simple. Sending out emails to a bunch of customers (roughly 600) with an attached report. It basically is a do while loop using the record and using the following. DoCmd.OutputTo acOutputReport, stDocName, acFormatPDF, FileName & ".PDF", False

Everything works fine but the memory just keeps climbing after each email and then it dies and says insufficient memory to process.

While watching it run under task manager under vista, you can see the releasing of memory on each report. The memory creeps up a small tad but nothing like it does under the newer version. The older version creeps up maybe 1 meg for 10 reports. So over 600 maybe 60 meg. The newer version, approx. 1-3 meg for every report and it basically just kills itself.

This is for an ADP.
Like I said the process is as follows:
1) get recordset of all customers
2) loop for each customer.
a) get email and customer attributes from recordset
b) execute docmd and create report.
c) email report.
3) Go get next customer.

Thanks. I have 2 databases left to convert over before I can rid of the Vista machine. Stuck right now.

Remember when... everything worked and there was a reason for it?

RE: memory leakage

This seemed familiar to me... I didn't find it with a quick google but ran across some debate on using compatibility mode with office 2007. It is worth a shot... I have not done that in Windows 10, so another search... usually part of a shortcut I think.

RE: memory leakage

running under ACCESS 10 and it seems to be handling the memory issue.

Remember when... everything worked and there was a reason for it?

RE: memory leakage

I am reading Access 2010 on Windows 10 fixes the issue. Is that correct?

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close