If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Not all data sources showing
I'm using Word 2003.
When selecting data sources for a letter, I select an Access database, but not all the queries show up after that. How can I get them to show for selection? Thanks for your help. |
#2
|
|||
|
|||
Not all data sources showing
Some query types won't show (Union queries, and Parameter queries) when
you connect with the default method in Word 2003, which is OLE DB. Typically you have to revert to the old DDE method (check Word Tools-Options-Confirm conversion at open, then go through the connection process again, and select the DDE option in the extra Confirm box that appears). If you are in a position to modify the database, you may be able to get some queries to run by wrapping them in a another query that simply does SELECT * FROM thequerythatOLEDBdoesnotsee The problem with parameter queries OLE DB is that OLE DB itself has no mechanism to prompt for the parameters, and nor does Word - with DDE, Access does it. To work around that, you have to use e.g. Word VBA to set up the parameters (prompting if necessary) then either generate the SQL text that the Query would issue, or use a special technique to run the query from Word VBA. I've never tired it for real, and it wouldn't surprise me if Microsoft hadn't blocked that particular option since I last looked. Peter Jamieson http://tips.pjmsn.me.uk SAC wrote: I'm using Word 2003. When selecting data sources for a letter, I select an Access database, but not all the queries show up after that. How can I get them to show for selection? Thanks for your help. |
Thread Tools | |
Display Modes | |
|
|