Determine Data Source

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

David - 31 Jan 2006 17:19 GMT

Hi, y'all.

We have a set of Word Merge files that make use of data from a variety of
different Access databases with identical data structures and queries.

When I click the 'Open Data Source' command button on the Mail Merge toolbar
it will allow me to select any Access database I want to relink to, but is
there any way to determine which Access database the Word document is
currently linked to before I change it?

Thanks in advance!

David

Reply to this Message

Doug Robbins - Word MVP - 31 Jan 2006 18:40 GMT

Running a macro containing the following command when the mail merge main
document is the active document will display a message box containing the
path\name of the data source.

MsgBox ActiveDocument.MailMerge.DataSource.Name

Signature

Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

> Hi, y'all.
>
[quoted text clipped - 10 lines]
>
> David

Reply to this Message

Cindy M -WordMVP- - 01 Feb 2006 17:16 GMT

Hi =?Utf-8?B?RGF2aWQ=?=,

> We have a set of Word Merge files that make use of data from a variety of
> different Access databases with identical data structures and queries.
[quoted text clipped - 3 lines]
> there any way to determine which Access database the Word document is
> currently linked to before I change it?

Which version of Word are you using?

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 8 2004)
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 :-)

Reply to this Message

David - 01 Feb 2006 18:42 GMT

2003

> Hi =?Utf-8?B?RGF2aWQ=?=,
>
[quoted text clipped - 15 lines]
> This reply is posted in the Newsgroup; please post any follow question or reply
> in the newsgroup and not by e-mail :-)

Reply to this Message

Cindy M -WordMVP- - 02 Feb 2006 16:35 GMT

Hi =?Utf-8?B?RGF2aWQ=?=,

> 2003
>

For this version, if I just want to check, I

- go to Help/About Microsoft Word, then click System Info
- From the tree structure at the left of this dialog box
- Applications/Office 2003 Applications/Microsoft Office Word 2003
- Select "Mail merge"
- all kinds of interesting things appear in the list on the right, including
full information about the data source

> > > We have a set of Word Merge files that make use of data from a variety of
> > > different Access databases with identical data structures and queries.
[quoted text clipped - 5 lines]
> > >
> > Which version of Word are you using?

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 8 2004)
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 :-)

Reply to this Message

Doug Robbins - Word MVP - 02 Feb 2006 18:52 GMT

Interesting, but on my system, that is not that long in the tooth, I think I
could write a macro to give me the information in the time that it took to
Refresh the System Information and display the results.

Signature

Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

> Hi =?Utf-8?B?RGF2aWQ=?=,
>
[quoted text clipped - 32 lines]
> reply in
> the newsgroup and not by e-mail :-)

Reply to this Message

Cindy M -WordMVP- - 03 Feb 2006 17:19 GMT

Hi Doug,

> Interesting, but on my system, that is not that long in the tooth, I think I
> could write a macro to give me the information in the time that it took to
> Refresh the System Information and display the results.

If you have an OLE DB connection, you may not get the entire connection
information through the VBA interface (granted, .Name will usually work; but
ConnectionString often won't).

-- Cindy Meister

Reply to this Message

David - 02 Feb 2006 20:06 GMT

Kewl! That helps a lot, too. This solution has the advantage that I don't
have to put a macro into the document and have to deal with macro security on
user's machines.

Thanks!

> Hi =?Utf-8?B?RGF2aWQ=?=,
>
[quoted text clipped - 26 lines]
> This reply is posted in the Newsgroup; please post any follow question or reply in
> the newsgroup and not by e-mail :-)

Reply to this Message