Issues with Word 2010 and Access 2010 as a data source for a mail mer

[bwesenberg]

Hello,

I have a new issue that has come up since we converted an Access database to 2007 file format.
Here is the history.

We have an access database that was created in the old file format. In that database there is a button that opens up word and a mail merge file. Word's mail merge then uses a query from the access database to populate the mail merge document.

We recently converted the Access database to the Office 2007 file format and now the merge process will not work.
I have tried to relink the files and have done some research and it appears that the DDE way of connecting is no longer used in Office 2007. I did finally get to the point where I could see the queries i needed but once I try to open that data source Word give me a general error that it can not open the data source.

How can I get these merge files working again?

PS. We are running Windows XP if that is needed.

We are quickly moving to office 2010 also but that uses the same file format as 2007 so I assume it won't be an issue. Any help you can give me would be GREAT!.
__________________
Becky, MCAS
IT Generalist

 

[SkipVought]

You realize that 2007 has a higher level of security than previous versions.

Make sure that you are ENABLING BOTH macros AND External Content, unless you have Trusted Settings that have defined one or the other or both.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}