Word 2007 doc taking large amount of memory

Posted on 2011-10-26
Last Modified: 2012-05-12
We run a mail merge document in Word 2007 that pulls its data from an ODC to our SQL server. I have noticed it bogging down the server it is running on so I watched it processing in the task manager. When it first opens it starts around 1500K of memory but by the time it is done it is well over 1 million K. After it is closed it slowly reduces the amount of memory consumption until around 500,000 where it stops and gets stuck.
The server is virtual running Windows 7 SP1. Any help is appreciated.
Question by:magnumtrucker
    LVL 38

    Expert Comment

    Try the relevant sections of this troubleshooter for problems with the MS SQL Server like the section entitled Troubleshooting the SQL Server ODBC Driver.



    Author Comment

    Thanks puppydogbuddy. Sadly I am not knowledgeable enough to understand what that docment was stating.
    LVL 38

    Accepted Solution

    that is going to make it difficult for experts to help, but see below.

    From your write-up, it appears that you are experiencing a "memory leak" only when the mail merge is executing.  Memory leaks can occur for many different reasons.  One possibility that is easy to check is that your odbc driver is outdated.  See

    Featured Post

    How your wiki can always stay up-to-date

    Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
    - Increase transparency
    - Onboard new hires faster
    - Access from mobile/offline

    Join & Write a Comment

    A few years ago I was very much a beginner at VBA, and that very much remains the case today.  I'll do my best to explain things as I go in the hope that other beginners can follow.  If you just want to check out a tool that creates a Select Case fu…
    PaperPort has a feature called the "Send To Bar". It provides a convenient, drag-and-drop interface for using other installed software, such as Microsoft Office. However, this article shows that the latest Office 2016 apps (installed with an Office …
    The viewer will learn how to simulate a series of sales calls dependent on a single skill level and learn how to simulate a series of sales calls dependent on two skill levels. Simulating Independent Sales Calls: Enter .75 into cell C2 – “skill leve…
    The view will learn how to download and install SIMTOOLS and FORMLIST into Excel, how to use SIMTOOLS to generate a Monte Carlo simulation of 30 sales calls, and how to calculate the conditional probability based on the results of the Monte Carlo …

    729 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    20 Experts available now in Live!

    Get 1:1 Help Now