Ian Gooding
asked on
Word 2010 mail merge not retrieving all records from Access query
I have a Word mail merge that's part of our Purchase Order suite, which is in a Word 2003 format doc, but accessed from Word 2010. The mail merge refers to an Access database with the query "SELECT * FROM 'Purchase Orders Query'". The query works correctly within Access, but in the Word mail merge it currently retrieves only records from before the end of 2012.
The Access database uses linked tables to a "hidden" database that contains the actual data, which is in a separate folder. This supports data entry and printing functions for our purchase order system, and has around 25000 records accumulated over 10 years or so. All the records appear to be visible from the linked tables within Access.
The server (Win Server 2008) the files are on doesn't seem to have been restarted for a long time, so this shouldn't be caused by anything there. We're in an Active Directory environment.
I've had this happen once before, and fixed it by rebuilding the query in the Word document, but this hasn't worked this time round, and it's quite a lot of work to set it all up so I'd rather find the cause of the problem rather than a workaround.
The Access database uses linked tables to a "hidden" database that contains the actual data, which is in a separate folder. This supports data entry and printing functions for our purchase order system, and has around 25000 records accumulated over 10 years or so. All the records appear to be visible from the linked tables within Access.
The server (Win Server 2008) the files are on doesn't seem to have been restarted for a long time, so this shouldn't be caused by anything there. We're in an Active Directory environment.
I've had this happen once before, and fixed it by rebuilding the query in the Word document, but this hasn't worked this time round, and it's quite a lot of work to set it all up so I'd rather find the cause of the problem rather than a workaround.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Then you should accept your own post as the solution...
This will make the actual answer more obvious to there members searching here for the same issue.
Please click the "Request Attention" link and ask that the accepted solution be changed to your post.
;-)
JeffCoachman
This will make the actual answer more obvious to there members searching here for the same issue.
Please click the "Request Attention" link and ask that the accepted solution be changed to your post.
;-)
JeffCoachman
You did not mention how you fixed this previously, so I am not quite sure where to tell you to look.
If you want to come at this from a different angle,...most "Mail Merges' can be simulated in Access quite easily with a report.
Thus eliminating the need to jump between two programs