Merge with secured Access DB

[Dale]

I am having trouble merging a letter in Word with a
mailing list I have as a select query in Access. I cannot
connect to the data source. Apparently, I cannot connect
via DDE. How do I connect using another method? Does ODBC
work? How do I set that up?

 

[Cindy M -WordMVP-]

Hi Dale,

I am having trouble merging a letter in Word with a
mailing list I have as a select query in Access. I cannot
connect to the data source. Apparently, I cannot connect
via DDE. How do I connect using another method? Does ODBC
work? How do I set that up?

to give you detailed instructions we need to know the
version of Word you're using? (And Access, as well, please)

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update
Sep 30 2003)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any
follow question or reply in the newsgroup and not by e-mail

 

[Dale]

Sorry, I'm using office XP.

The DB is in an access 2002 format and this is driving me
crazy now. Any help is greatly appreciated.

D.

 

[Cindy M -WordMVP-]

Hi Dale,

office XP.

The DB is in an access 2002 format

I am having trouble merging a letter in Word with a
mailing list I have as a select query in Access. I cannot
connect to the data source. Apparently, I cannot connect
via DDE. How do I connect using another method? Does ODBC
work? How do I set that up?

Right, DDE won't work between different Office versions.

You can use ODBC. Activate "Confirm conversions on open" in
Tools/Options/General, then connect to the Access database.
In order to see the list of queries with the tables, click
"Options" and activate "Views".

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update
Sep 30 2003)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any
follow question or reply in the newsgroup and not by e-mail