Merge Doc (MSO 2010) does not see all recordsin Access 2K sourc fille 1

[jlockley]

I am running Access 2000 and Home Office 2010 on Windows 7. I have been having considerable challenges with merges (for instance changing the data source..there must be a way?)
The merge interface only shows 7 of the twelve records, excluding those recently added.
The file was saved and was not open at the time of the attempted merge.
??????????
After exporting the file to Excel, which I could not however enter as the source file, I could suddenly access the new fields.
?????
The issue is resolved for now, but lightning strikes repeatedly, so some understanding of the problem would be beneficial.
Thank you.

 

[macropod]

Changing the data source is as simple as answering 'No' to the SQL prompt, then doing the mailmerge setup with the new data source.

Cheers
Paul Edstein
[MS MVP - Word]

 

[jlockley]

Oh, duh. Of course. Never occurred to me. Any idea why it's not picking up on recently entered records (thinking that the sql script somehow brings up the non updated file, but can't see how.)

 

[macropod]

Are you sure there wasn't a copy of the datasource in the old location pointed to by the SQL statement (and that that statement pointed to where you thought it did)?

The only other thing I can think of that might account for it is that some form of record filtering was being used.

Cheers
Paul Edstein
[MS MVP - Word]

 

[jlockley]

No, there's only one copy of the file, and I pointed the document to it to begin. No filtering. I had entered the three new billing addresses yesterday and put off cutting the invoices until today. Closed down both programs. Today Word could not see the last entered records, although they were clearly there when I opened the file. Definitely strange. Thank you. If need be I will in future just export the file to Excell and work with that.