Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Importing / Linking / July 2005

Tip: Looking for answers? Try searching our database.

Multi-table queries are not visible as datasource for a Word table

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
kfschaefer - 27 Jul 2005 23:23 GMT
I am currently setting up a Word doc that will contain multiple tables based
on 100's of queries from Ms Access.  I understand the how to , but not why I
am unable to view the complete list of queries from my Access mdb only those
queries with a single table source or the tables themselves.  All queries
that contain multiple data sources are not in the list of datasources when I
select the database tool in Word.  Is there a piece I am missing or do I have
to convert all my queries into tables?

Thanks,

Karen

Signature

Karen

david epsom dot com dot au - 28 Jul 2005 10:41 GMT
You will see them if you use ODBC or DDE instead of OLEDB.

Ask in a Word group for more information on how to
tell Word to use ODBC or DDE.

(david)

>I am currently setting up a Word doc that will contain multiple tables
>based
[quoted text clipped - 12 lines]
>
> Karen
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.