Normally you see all the queries, especially when you connect from Word
using the default mechanism (DDE), which opens a copy of Access.
However, it is possible that the queries have been inserted in a way that
makes them invisible to Word, or that someone has marked them as Hidden in
the Properties for the query in Access, or that the database uses workgroup
security and the queries are not visible to the default user ("Admin"). Or
maybe there is something else you can see that is special about the hidden
queries? If you are allowed to add material to this database, you might be
able to work around this problem by adding new queries that simply do
SELECT * FROM queryname
for each query you cannot see.
Peter Jamieson
>I am trying to set up a mail merge in word 2000 to an acces database,
>however
[quoted text clipped - 4 lines]
> Thanks
> Tiani
tweetyangel - 15 Mar 2005 22:05 GMT
I am having the same problem. Any query that contains a prompt as a
condition does not show up anymore. The only way to get them to show up is
to remove the prompt, this causes the users of mail merge to have to edit the
recipient list and limit the data in Word instead of in Access. This is
horrible!
> Normally you see all the queries, especially when you connect from Word
> using the default mechanism (DDE), which opens a copy of Access.
[quoted text clipped - 21 lines]
> > Thanks
> > Tiani
tweetyangel - 15 Mar 2005 22:17 GMT
I just found another post that tells you how to work around this... awesome!!!
"From the Tools menu, select Options and then go to the General tab and check
the "Confirm conversions at open" item. Then try the other methods of
connecting to the data source that will become available to you."
> I am having the same problem. Any query that contains a prompt as a
> condition does not show up anymore. The only way to get them to show up is
[quoted text clipped - 27 lines]
> > > Thanks
> > > Tiani