Re: Problem with MailMerge and performance

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

I use SQL Server view as the data source and it is a Windows 2K3
server. All the mail merging is done on the client though. I have also
logged the actions, and I've concluded that the Document.Add action is
the one that takes the longest. With administrative rights it takes
approximately one second, and without administrative rights it takes up
to 17 seconds doing the exact same thing. Could there be a
configuration in Word that could cause this? That's the only thing that
I can think of that could be different between the users. Note that the
tests were run on the same client, only with different users.

OK, then we have to consider what kinds of things could be happening when
Word generates a new, mail merge document

1. Is this document template already connected to the SQL Server data
source? If it is, we could still be looking at a problem with the
connection. If you try to log into the same view "manually" through some
interface, first as an admin, then as a "normal user", do you notice any
significant difference in the time it takes to access the view?

2. Does the template contain any VBA macros - AutoNew or DocumentNew -
that cuold be executing?

3. What kind of permissions does the folder where the template is stored
have?

4. Could there be any Add-ins installed in the "normal user" profile that
are capturing the DocumentNew event, perhaps?

5. If your app doesn't start Word, but uses (or can use) an existing
instance, try starting Word in Safe Mode (hold down CTRL) then create the
mail merge. If there is an Add-in or something, you should notice a
significant difference when running in Safe Mode.

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 17 2005)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any follow question or
reply in the newsgroup and not by e-mail :-)

.

Relevant Pages

  • SBS 2K3 server non-boot issues
    ... A client is running Small Business Server 2K3 SP1 on a Dell PowerEdge ... addition to full hardware diagnostics, ... The server will boot into safe mode / safe mode with network without ...
    (microsoft.public.windows.server.sbs)
  • Re: SBS 2K3 server non-boot issues
    ... A client is running Small Business Server 2K3 SP1 on a Dell PowerEdge ... addition to full hardware diagnostics, ... The server will boot into safe mode / safe mode with network without ...
    (microsoft.public.windows.server.sbs)
  • Re: How to connect to remote server from a machine over the network and query active directory for g
    ... Suppose this script is example.vbs. ... the local machine (client) as a normal user with less prvileges. ... when I run this script on the remote server win 2003 from a client, ...
    (microsoft.public.windows.server.scripting)
  • Re: What doesnt lend itself to OO?
    ... >> proxy and instructs the server to constuct the real object. ... rather than client code. ... If 'clock' is instantiated in the server, ... > for the server interface at the OOA level. ...
    (comp.object)
  • This is going straight to the pool room
    ... or not the client has privilege to do what they're trying to do, ... The server environment is this: ... 3GL User action Routines that Tier3 will execute on your behalf during the ... Routine Name: USER_INIT ...
    (comp.os.vms)