I do have a
few fields where the user can select multiple data items, do you think
this
could be causing all of this?
It's possible, but the small tests I have done suggest that these fields
(you do mean the multivalue lookup type fields?) do not seem to prevent
connection in themselves.
But when you say this...
(checked the version of each file and have confirmed the file format
conversion on open).
presumably that is because you need to use DDE - if so,
a. what's in your query that needs a DDE connection? Is it a parameter
query?
b. Access 2007 seems to work rather differently with DDE than previous
versions, e.g. you probably don't see the new version of a query until you
close/re-open the Word document and/or the database. But perhaps I am
misremembering.
--
Peter Jamieson
http://tips.pjmsn.me.uk
"Melynda E." wrote in message
...
I am creating a mail merge in Word using data pulled from an Access query.
Once I select this query as my recipient list, I receive an error message
"unable to open data source." I've checked other posts to solve the
problems
(checked the version of each file and have confirmed the file format
conversion on open). I had it working, but realized a field needed to be
added to my query. The query was then updated, the merge would not work
and
the error message was received again. I went back to the query and
removed
the newly added field and tried it again....same error message. I do have
a
few fields where the user can select multiple data items, do you think
this
could be causing all of this?