Thanks for your ongoing help and insight.
Whenever I open the Word template it prompts me to choose a data source. I
select the database in the standard file opening dialog box. A dialog box
titled Confirm Data Source then (and has in all tests) popped up prompting me
to select the connection type. There are always three options: OLE DB, DDE,
and ODBC - I always select DDE. The DDE option I select states "MS Access
Databases via DDE (*.mdb;*.mde)" - DDE connections for other Office products
only appear when I select "Show All".
"Peter Jamieson" wrote:
I've
selected the DDE connection in all tests
Can you clarify this - it occured to me that you might mean that you
select DDE whenever it is offered, and it would not be offered if either
a. you have not enabled Tools-Options-General-Confirm conversions
at open (on Word 2003) or the equivalent on Word 2007
b. you were connecting to a .accdb rather than a .mdb in which case
you'd only see the OLE DB option unless you check the "Show All" box
Another thing I noticed is that if you check the Show all box and choose
the wrong type of DDE connection (that would be possible even for .mdb)
e.g. if you chose Excel via DDE, Word will indeed open Excel, get it to
open the accdb/mdb, and present an OLE DB-style list of tables.
Peter Jamieson
http://tips.pjmsn.me.uk
Visit Londinium at http://www.ralphwatson.tv
Mathew Winder wrote:
Thanks for the input!
I forgot to mention that I'm connecting to the database via a DDE connection
- though you seem to be mostly right; the computer that works is displaying
the DDE dialog box while the ones that don't show the OLE DB dialog. I've
selected the DDE connection in all tests, so I'm really confused why it would
show any other dialog box.
Any ideas?
"Peter Jamieson" wrote:
Quick response because I have to go: It sounds to me as if some of your
PCs are seeing the ODBC connection dialog box (where tables and
queries/views are probably separated) and other PCs are seeing the OLE
DB dialog box (where all the tables and queries that OLE DB wants to
present to you are shown in a single list).
Peter Jamieson
http://tips.pjmsn.me.uk
Visit Londinium at http://www.ralphwatson.tv
Mathew Winder wrote:
I'm working to create a registration sheet that will pull known data from an
Access database and plug it into a Word template via mail merge. The data in
Access is contained in a query that uses Joins to pull data from a few
different tables.
While the whole procedure works fine on one of the computers in the office,
it doesn't seem to on any of the others.
When I am picking my datasource in Word I am able to find the database,
however the list of tables and queries to choose from does not include any
queries that contain an SQL join. On the computer that works correctly it
seems to be a different dialogue box altogether; it has queries and tables
split between different tabs whereas the other is just one list, etc.
I'm really at a loss for what may be causing this, let alone how I might go
about fixing it. Any ideas would be greatly appreciated.