Re: Vista compatibility problems with Word 2000 mailmerge
- From: "Peter Jamieson" <pjj@xxxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Wed, 26 Dec 2007 18:10:24 -0000
If you are starting from a new Vista installation, the thing most likely to be missing on your system is the ODBC DSNs that your Word documents (and possibly Access databases) expect to find. A DSN is a "Data Source Name" that you can create in the ODBC Administrator - have a look at Vista button|Control Panel|Administrative tools (if you can find that)|Data SOurce (ODBC). It is possible that the DSNs you had on your previous system have not been created by Vista or during re-installation of Office 2000. In particular, there should probably be a "User DSN" called "MS Access Database". If your system was set up by someone else, it is also possible that they created DSNs for specific purposes. Unfortunately, because you cannot open a WOrd Mail Merge Main Document unless the data source is present, it is sometimes impossible to discover what the data source used to be (as you have discovered,).
1. Law database must be properly linked to Raw Data or nothing in word works.
What do you have to do to achieve this linking? Are you linking a front-end Access database to a back-end one, or is this something else altogether? If you are linking via ODBC and are having problems linking, it could also be because of a missing DSN.
--
Peter Jamieson
http://tips.pjmsn.me.uk
"jrtman50" <jrtman50@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message news:134FC826-4E6C-46BA-B3CF-F0DB0785F391@xxxxxxxxxxxxxxxx
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" <jrtman50@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:FB00E3D8-DB82-4D6F-AED5-D099EEA9DC57@xxxxxxxxxxxxxxxx
>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?
.
- References:
- Re: Vista compatibility problems with Word 2000 mailmerge
- From: Peter Jamieson
- Re: Vista compatibility problems with Word 2000 mailmerge
- From: jrtman50
- Re: Vista compatibility problems with Word 2000 mailmerge
- Prev by Date: Re: labels problem
- Next by Date: Re: Label lines are not showing
- Previous by thread: Re: Vista compatibility problems with Word 2000 mailmerge
- Next by thread: Re: Cannot get label document though show gridlines is ticked
- Index(es):
Relevant Pages
|
