ODBC Access-DB connection save-problem with the last DB-record

[Helga]

I have a mailmerge with fields from an ODBC Access-DB and Word.
The DB has now more then 500 record.
When I save the word-Document with the last record,
the connection with the last record will not show again, when I open
the Word-Document again,
but it is connected with the record number 1.
All is allright, if it is not the last record but the record before,
the Word-Dokument opens after saving correctly with the connected
record number before.
This wrong behavior was first appearing, after the DB has more than
500 records.

Is there a bug in Word when mailmerging with an ODBC-DB, that has more
than 500 records?

 

[Cindy M -WordMVP-]

Hi Helga,

Which versions of Word and Access are involved, here?

I have a mailmerge with fields from an ODBC Access-DB and Word.
The DB has now more then 500 record.
When I save the word-Document with the last record,
the connection with the last record will not show again, when I open
the Word-Document again,
but it is connected with the record number 1.
All is allright, if it is not the last record but the record before,
the Word-Dokument opens after saving correctly with the connected
record number before.
This wrong behavior was first appearing, after the DB has more than
500 records.

Is there a bug in Word when mailmerging with an ODBC-DB, that has more
than 500 records?

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Sep 30 2003)
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

 

[Helga]

Access and Word version 2002 with SP-2 under Windows XP Home Edition

 

[Cindy M -WordMVP-]

Hi Helga,

I've never heard of this problem, that I can recall. I'm trying to find
something out, but even if I get a confirmation that it is a problem, I
doubt it will get fixed for Word 2002.

Best I can suggest,
given that you know of a way to get around it, would be to use a macro
that fires when the document is closed that will reset the active
record. This might work

Sub AutoClose
'Below should all be on one line, except "End Sub"
ActiveDocument.MailMerge.DataSource.ActiveRecord = wdPreviousRecord
End Sub

Access and Word version 2002 with SP-2 under Windows XP Home Edition

I have a mailmerge with fields from an ODBC Access-DB and Word.
The DB has now more then 500 record.
When I save the word-Document with the last record,
the connection with the last record will not show again, when I open
the Word-Document again,
but it is connected with the record number 1.
All is allright, if it is not the last record but the record before,
the Word-Dokument opens after saving correctly with the connected
record number before.
This wrong behavior was first appearing, after the DB has more than
500 records.

Is there a bug in Word when mailmerging with an ODBC-DB, that has more
than 500 records?

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Sep 30 2003)
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