Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
No of fields in a Data Source
MS-Access 97 is used to generate a TEXT datasource - then via automation
loads MS-Word 97 connected to this text data source. This TEXT datasource contains ONE record - with over 300 fields and this process has been working fine with Win 98 and Win 2000 for years (just keeps going regardless of how many fields added). The client just updated a PC with Win XP but kept their Word97 software license as its all they need, and now the same process fails to recognise the data source. I can easily open and connect when MS-Word 97 is running on a Win98 or Win 2000 PC - but MS-Word 97 refuses to connect to the data source on the XP machine. I have discovered that if I reduce the number of fields to exactly 256 - it connects fine - if I increase the number of fields to 257 it fails. Has anyone seen this problem and if so how can it be resolved? |
#2
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
No of fields in a Data Source
Hi ?B?c3lmYW0=?=,
Likely, this is a question of the connection method plus MDAC version. First thing you'd need to ascertain is, which connection method is/was used to link the data source into the document. 1. The document is already connected to the data source? Or automation also takes care of doing the connecting? 2. Assuming the data source was connected into the document manually: What steps (exactly) were followed in Word to make the connection? If the connection is done using VBA, what's the OpenDataSource code? 3. Do you have any way of finding out whether the ODBC Text driver was installed on the old machine? By default, Word 97 would have used that if it was present. But the text ODBC drivers have changed in the meantime and Word 97 could be having problems with that. You might need to remove the ODBC driver from the installation, uninstall then reinstall Office again so that it loads its text ODBC driver (I think you have to select it, explicitly, during setup). MS-Access 97 is used to generate a TEXT datasource - then via automation loads MS-Word 97 connected to this text data source. This TEXT datasource contains ONE record - with over 300 fields and this process has been working fine with Win 98 and Win 2000 for years (just keeps going regardless of how many fields added). The client just updated a PC with Win XP but kept their Word97 software license as its all they need, and now the same process fails to recognise the data source. I can easily open and connect when MS-Word 97 is running on a Win98 or Win 2000 PC - but MS-Word 97 refuses to connect to the data source on the XP machine. I have discovered that if I reduce the number of fields to exactly 256 - it connects fine - if I increase the number of fields to 257 it fails. Has anyone seen this problem and if so how can it be resolved? 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 :-) |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Why will mailmerge not use all the fields from data source? | Mailmerge | |||
How do I create a read-only mail merge data source? | Mailmerge | |||
How can I add data fields to a data source in Word Mail Merge? | Mailmerge | |||
How do I add more data fields to a data source | Mailmerge | |||
Using excel as a data source, but only getting 63 fields | Mailmerge |