Peter, you are correct, I didn't "upgrade" to Vista, I got a new Vista
computer. I figured out how to get the link back between the Access Query
and the Word mail merge template, but it takes as lot of work since I have so
many different queries and the mail merge docs don't specifiy which query
they are tied into. The following is what I must do for EACH mail merge doc
to get it working again. I don't know enough about the actual programming
language to understand how these problems developed. Thanks for your input.
Jeff
1. Law database must be properly linked to Raw Data or nothing in word works.
2. Open template as document, not template.
3. Click tools on drop down menu.
4. Select Mail merge.
5. Select data source, Get Data.
6. Open data source.
7. At files of type select: choose MsAccess.
8. Check select method.
9. Double click Law.
10. Check Show All.
11. Select MsAccess Database via ODBC (*.mdb)
12. Click Ok.
13. Switchboard Items should be showing. Select Options.
14. Check Tables; Check Views.
15. Click OK.
16. Select proper query.
17. Click Ok.
18. Close.
19. Save template.
"Peter Jamieson" wrote:
I'm not in a position to diagnose this problem, but
1. If you had to install Vista from scratch (I know you said "upgrade", but
some people have to do that) you may have lost any ODBC data source names
that Microsoft Word expects. If you can go
if Vista is complaining about the ODBC components, I would consider trying
to re-install them. ODBC is included in Vista (the 32-bit version, at any
rate) but see
http://support.microsoft.com/kb/870630/en-us
You might also need this, although it doesn't sound like it to me:
http://support.microsoft.com/kb/937248/en-us
--
Peter Jamieson
http://tips.pjmsn.me.uk
"jrtman50" wrote in message
...
I upgraded to Vista from XP and now none of my Word 2000 mailmerge document
work. I receive €śOpen database connectivity error. No data source name
found or default driver.€ť The program freezes if I try to relink the
template
to an access query. The mailmerge is tied into queries in Access 2000.
The
links between Word and Access no longer exist or are not accessible. If I
try to make a new mailmerge docs from scratch, several copies of Access
are
immediately opened each time I create a new mailmerge document or open
one.
I would like to use all of the mailmerge docs I created in Office 97 &
Office
2000, which worked fine and didn't open a copy of access each time I
opened
the mailmerge doc. Any suggestions? Am I out of luck using vista?