How do you connect Word 2003 to Access 2007 accdb database???

  • Thread starter Thread starter JimG
  • Start date Start date
J

JimG

I posted this in the Word Mailmerge Group also but maybe someone from the
Access 2007 group might have a solution.

We have both Word 2003 and Access 2007 published on a Citrix Server and
cannot upgrade Word to 2007 (easy solution I know). When we create a mail
merge in Word 2003 it does not see an Access 2007 accdb database (we cannot
change to a Access 2003 mdb format - the other easy solution). Is there an
add-in or update that will allow Word 2003 to connect to an Access 2007 accdb
database?
 
On Sun, 27 Sep 2009 13:31:01 -0700, JimG

I don't have your configuration here, but can't you create an ODBC
datasource to the ACCDB, and select it from Word?

-Tom.
Microsoft Access MVP
 
JimG said:
I posted this in the Word Mailmerge Group also but maybe someone from the
Access 2007 group might have a solution.

My super easy word merge will work in this case.....

The sample I have can be found here:
http://www.members.shaw.ca/AlbertKallal/msaccess/msaccess.html

What is nice/interesting about my sample is that is specially designed to
enable ANY form with ONE LINE of code....

Thus, each time you build a new form, you can word merge enable it with
great ease.

Make sure you read the instructions from above, and you should eventually
get to the following page
http://www.members.shaw.ca/AlbertKallal/wordmerge/page2.html


Note that the merge can also use a query, and thus you don't have to merge
just "one" record..

After the merge occurs, you get a plain document WITHOUT any merge fields,
and this allows the end user to save, edit, or even email the document
(since the merge fields are gone after the merge occurs).

Give the above a try....
 
Back
Top