Re: Data Source Problem

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Thanks a lot Peter! It works great!

-Matt

"Peter Jamieson" wrote:

OK, I can't check in Word 2000 right now, but the following works OK on WOrd
2003 on a WinXP box:

(b)

When you get to the Open Data Source dialog box, type in the UNC name (i.e.
don't try to select the .mdb file from a list). e.g. I just used

\\Myserver\netshare\a.mdb

However, I have a feeling that there may be more to it than that in Word
2000, e.g. you may have to take account of

http://support.microsoft.com/kb/313551/en-us

c. How do I connect programmatically in Word?

Issue an OpenDataSource call, e.g. with your mail merge main document open,
use

Sub COnnectToMyDB()

ActiveDocument.MailMerge.OpenDataSource _
Name:="\\Myserver\netshare\a.mdb", _
Connection:="TABLE mytable", _
SQLStatement:="SELECT * FROM [mytable]"

End Sub

See http://word.mvps.org/FAQs/MacrosVBA/CreateAMacro.htm

if you're unfamiliar with creating VBA code.

Peter Jamieson
"MF Scheetz" <MFScheetz@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:CD6C5273-7BA0-4BF9-8C74-E7746B33A951@xxxxxxxxxxxxxxxx
a. DDE
b. I don't know how to specify the UNC in Word. I only know how to
connect
with the Mail Merge Helper ( I hate helpers/wizards, its just that I don't
know another way to link the db to the word doc.)
c. How do I connect programmatically in Word?

"Peter Jamieson" wrote:

I'd have to experiment here, but
a. Are you connecting using DDE or ODBC?
b. have you tried doing the connection by specifying the UNC path then
distributing the app?
c. I'm assuming you're connecting manually, but maybe you are, or could
be,
connecting programmatically?

Peter Jamieson

"MF Scheetz" <MFScheetz@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:5B9530E4-9D3E-473D-B273-E3AAED732E89@xxxxxxxxxxxxxxxx
I've got an Access 2K DB on my server and it merges to many (40+) word
2K
documents. The problem is half my users have the selected server
mapped
as
L: the other half have it as K:.

I've set up the database merges on my system, using the mapped L:
drive.
All users with their computers mapped to L: can merge the documents
with
no
problems. Users with the drive mapped to K: open the merge documents
but
the
documents cannot find the source data.

I'm assuming this is because of the mapping.

Is there any way to get all users to merge the documents with out
mapping
all drives to L:?

Can word be programmed to look for the UNC path and not the mapped
path?

Thanks in advance,

Matt






.

Relevant Pages

  • Re: Data Source Problem
    ... "Peter Jamieson" wrote: ... Are you connecting using DDE or ODBC? ... all drives to L:? ... Can word be programmed to look for the UNC path and not the mapped ...
    (microsoft.public.word.mailmerge.fields)
  • Re: Odd behaviour merging text with CHR(13)
    ... > - Connecting via OLE DB Database Files or Text Files ... >> Peter Jamieson ... >>> Can anyone advise if this is some kind of strange setting please. ...
    (microsoft.public.word.mailmerge.fields)
  • Domain name required
    ... want to access files on the other domain, we access them using UNC. ... we are prompted with a username and password box. ... followed by the passsword for the domain I'm connecting to. ...
    (microsoft.public.windows.server.security)
  • Re: If statement problems in mail merge
    ... > Another reason for doing the data manipulation in the database ... > Please reply to the newsgroup unless you wish to avail yourself of my ... >> you are connecting to your access/jet data file. ... >> Peter Jamieson ...
    (microsoft.public.word.mailmerge.fields)
  • Re: Only 1 page of labels appear
    ... How are you connecting to the data source? ... or using the facility in Word's Mail Merge Wizard? ... "Peter Jamieson" wrote: ... either by merging to a new document or merging to a printer - if you're ...
    (microsoft.public.word.mailmerge.fields)