Re: newer versions of Word take longer to merge

Tech-Archive recommends: Fix windows errors by optimizing your registry

anonymous_at_discussions.microsoft.com
Date: 07/06/04 

Date: Tue, 6 Jul 2004 08:10:26 -0700

Thanks Cindy. Yes, I am looking at the code that we use
to specify a DSN (that uses ODBC), specify a username and
password, and then do a select statement from our
database to give results to Word. Those results are
provided to Word along with the path to a .dbf file where
the results structure is contained.
>-----Original Message-----
>Hi MattD,
>
>I see you've posted this twice, no answer...
>
>Are you absolutely certain this is an ODBC connection,
and
>that OLE DB isn't kicking in here? Are you using Word's
>default connection, or selecting the DSN entry
explicitly,
>when connecting to the data source?
>
>> Compared to Word 97 and 2000, Mail Merge in word 2002
and
>> 2003 take MUCH LONGER. Is there a way to get this to
>> take less time? Merging a single document could take
as
>> long as 30-60 seconds (one page document). The same
>> document with the same data source on 97 or 2000 takes
>> less than 5 seconds.
>>
>> The problem occurs on this statement:
>> ActiveDocument.MailMerge.Execute
>> We use ODBCs to connect to our database, using the
dBase
>> Driver DSN. The data source is populated by our
>> client/server app to a local .dbf file.
>>
>> Suggestions? Why would Word version drastically
change
>> the merge speed?
>>
>
>Cindy Meister
>INTER-Solutions, Switzerland
>http://homepage.swissonline.ch/cindymeister (last update
Jun
>8 2004)
>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

  • Re: Mail Merge to a secured Access database
    ... and how did you try to reference the workgroup file? ... you can connect using ODBC, but if you want to connect using the Word ... if you do not also specify a login name and password in the DSN, ... DSN for Access to specify a particular workgroup file ...
    (microsoft.public.word.mailmerge.fields)
  • Re: Using Secured Access Database as Datasource
    ... you can connect using ODBC, but if you want to connect using the Word ... if you do not also specify a login name and password in the DSN, ... DSN for Access to specify a particular workgroup file ...
    (microsoft.public.word.mailmerge.fields)
  • Re: Using user id and pwd in data source name
    ... If you have a DSN, then all you need to do is to specify this DSN in your ... connection string and it should work. ... ADO does not work with ODBC directly, then ADO will place OLEDB for ODBC ... In the system dsn you>specify all the ODBC information like user, password, server, database>name, etc. ...
    (microsoft.public.data.ado)
  • Re: Word 2000/2002 - Proper Mail Merge steps for ODBC?
    ... > Document to connect to a Secured Access Database, ... using the ODBC provider for OLEDB. ... they have a .dsn extension. ... directly (in the Open/Select Data Source dialog box). ...
    (microsoft.public.word.mailmerge.fields)
  • Re: Silly ODBC Connection problem
    ... it seems to me this must be done interactively on each client--either that or use the magical "DSN-less" connection. ... It's been 11 or years or so since I wrote about ODBC so it's getting kinda fuzzy. ... 556-9205 (Pacific time) ... > created a System DSN named "MyDSN" in the ODBC Administrator tool. ...
    (microsoft.public.dotnet.framework.adonet)