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.