Re: office 2003 Word mailmerge with Access

Hi Beth - Thank you very much - I think it very likely that this is the
problem - I will know for sure when I visit that client again to try it!
--
Jon


"Beth Melton" wrote:

Word 2003 uses a new default connection method, OLE DB, to connect to
the Access database. If you aren't able to see all of the queries then
it's likely due to the connection method rather than permissions. Try
changing the connection method to the same one you was used in Office
97. If you didn't specify a connection method then I'd say you used
the default which is DDE:

- In Word go to Tools/Options/General and turn on "Confirm conversions
at Open"
- Select the Access database as the data source again and when
prompted select the DDE Method

Please post all follow-up questions to the newsgroup. Requests for
assistance by email can not be acknowledged.

~~~~~~~~~~~~~~~
Beth Melton
Microsoft Office MVP

TechTrax eZine: http://mousetrax.com/techtrax/
MVP FAQ site: http://mvps.org/

"JonGuildford" <JonGuildford@xxxxxxxxxxxxxxxxx> wrote in message
news:9A2CC383-0810-443F-91C9-52C073F6001E@xxxxxxxxxxxxxxxx
I have recently converted an Access database and associated Word
merge
documents from Office 97 to Office 2003.

It has generally gone well, but I now find that from Word 2003 that
only
some, but not all, of the queries in the associated Access 2003
database are
visible, when trying to reset the source as a query in the new
version of the
database.

There is a database workgroup file which Access has joined, and the
user has
all permissions on ALL queries - we don't see any differences
between the
queries which can be seen and those which cannot in this respect..

When the Word document is opened, there is no request to sign on as
there
used to be in the old version - I don't know if this is relevant.

How can I make sure that ALL queries are visible as potential word
data
sources?

--
Jon



.

Relevant Pages

  • Re: office 2003 Word mailmerge with Access
    ... Word 2003 uses a new default connection method, OLE DB, to connect to ... If you aren't able to see all of the queries then ... Select the Access database as the data source again and when ...
    (microsoft.public.office.misc)
  • Re: Queries missing from Access data source list
    ... Word does not "see" certain types of query when it connects to the database ... which is the default connection method in Word 2002 and later. ... In particular, it does not "see" UNION queries, parameter queries, queries ...
    (microsoft.public.word.mailmerge.fields)
  • Re: Multi user VB6 Access Backend Database
    ... > I have a VB6 application which has to use an MS Access database as a back ... Usually use SQL Server. ... > Database', and the queries: ...
    (microsoft.public.vb.database)
  • How can I automate an odbc connection
    ... I have a MS Access database - inside the database are linked Sybase ... I have a VBA module that runs the queries - below ...
    (microsoft.public.data.odbc)
  • Re: Missing Objects in Database window
    ... >>I have an access database that has a number of tables, queries and reports. ... > and back will restore them - sounds like this is some other problem! ...
    (microsoft.public.access.gettingstarted)