Mail Merge with Access query linked to SQL tables

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Jillen - 28 Jun 2006 18:34 GMT

Hi,
I just can't figure this out! I have a mail merge that works with an Access
2000 parameter query (with linked Access tables). Been working for months.

I've changed the parameter query to use linked SQL Server tables and it
works fine from Access. When I try to connect the new query to my Word
document, I'm unable to see the new query in the list. I've seen other
suggestions that say to make sure to save the passord in the odc file. This
allows me to see the query, but when I select it, nothing happens (i.e. no
selection list opens.)

Any ideas? Thanks!
Joanne

Reply to this Message

Sylvain Lafontaine - 28 Jun 2006 21:07 GMT

This newsgroup is about ADP and SQL-Server and not about ODBC linked tables
or Mail merge from Word; you should ask in a more appropriate newsgroup.

As to your problem, there is often many problems when you try to get to a
SQL-Server using an intermediary MDB file instead of using a direct
connection and somes of these problems are related to a bad
authentification. Don't forget that you don't authenticate directly with
the SQL-Server; you only authenticate with the MDB file.

If I were you, I would deal only with the SQL-Server if I wanted to access
data from it from Word; that's my two cents.

Signature

Sylvain Lafontaine, ing.
MVP - Technologies Virtual-PC
E-mail: http://cerbermail.com/?QugbLEWINF

> Hi,
> I just can't figure this out! I have a mail merge that works with an
[quoted text clipped - 12 lines]
> Any ideas? Thanks!
> Joanne

Reply to this Message