Can you still connect manually using DDE in a simpler scenario where you
aren't initiating the thing from Access? FWIW I probably get much the same
updates as you and I can still do that...
FWIW with normal merges the fact that the data is coming from a query is not
in itself a reason why you have to connect using DDE. If the query is a
parameter query (doesn't sound like it) or uses old-style wildcards, or
several other things, you might have to use DDE. I just wonder whether you
should try an OLE DB connection.
--
Peter Jamieson
http://tips.pjmsn.me.uk
"David L" wrote in message
...
Hello Peter and Sarah,
I am having similar problems with mail merge to word from an access
database
located on a server, but the security settings haven't been created yet.
Everyone on the network is running XP, Word 2003 and Access 2003. The
linkage between word and access used DDE because the merged data comes fom
queries, not tables. After the user generates the query, they press a
button
on the form with a hyperlink to the pre-linked word file. Word opens up
but
then tries to open Access again on its own, and can't find the link it was
saved with.
The crazy part is that everything worked fine yesterday. I am wondering if
the problem is created by security updates that installed automatically
during shutdown yesterday.
I welcome your suggestions.
Sincere regards,
David
"Peter Jamieson" wrote:
OK, I was obviously hoping to compare the two, but there is certainly
nothing unexpected in there.
I
think the problem is with security settings in the database itself,
although
I don't know why that should effect merging data.
That could well be the case The thing that doesn't quite add up is if
they
are managing to make the connection /eventually/. If it is a
security-related problem then you have to consider
a. what permissions people have to access the folder containing the .mdb
and and .mdw you may have
b. what permissions people have to access the share that P: is mapped to
c. whether you have an Access database password or workgroup level
security
(with a .mdw) and what permissions the users have for the objects in the
database that the query uses
d. if you are using linked tables, what permissions the users have to
access the underlying tables.
Not sure if that gives you anything that can help you get any further,
but
perhaps some of the possibilities can be eliminated.
--
Peter Jamieson
http://tips.pjmsn.me.uk
"Sarah G" wrote in message
news
The following is the code you asked for from my login account. I was
unable
to save a web page from the other person's account as it created an
error.
I
think the problem is with security settings in the database itself,
although
I don't know why that should effect merging data.
w:MailMergeMainDocTypeMailingLabels/w:MailMergeMainDocType
w:MailMergeLinkToQuery/
w:MailMergeDataTypeODSO/w:MailMergeDataType
w:MailMergeConnectStringProvider=Microsoft.Jet.O LEDB.4.0;Password="";User
ID=Admin;Data Source=P:\MastMail\dbBiState
Mastermail.mdb;Mode=Read;Extended
Properties="";Jet OLEDB:System database="";Jet OLEDB:Registry
Path="";Jet
OLEDBatabase Password="";Jet OLEDB:Engine Type=5;Jet OLEDBatabase
Locking
Mode=0;Jet OLEDB:Global Partial Bulk Ops=2;Jet OLEDB:Global Bulk
Transactions=1;Jet OLEDB:New Database Password="";Jet OLEDB:Create
System
Database=False;Jet OLEDB:Encrypt Database=False;Jet OLEDBon't Copy
Locale
on Compact=False;Jet OLEDB:Compact Without Replica Repair=False;Jet
OLEDB:SFP=False/w:MailMergeConnectString
w:MailMergeQueryStringSELECT * FROM `qryCEDS`
/w:MailMergeQueryString
w:MailMergeDataSource HRef="P:\MastMail\dbBiState
Mastermail.mdb"/w:MailMergeDataSource
w:Odso
w:UdlProvider=Microsoft.Jet.OLEDB.4.0;Password=" ";User
ID=Admin;Data
Source=P:\MastMail\dbBiState Mastermail.mdb;Mode=Read;Extended
Properties="";Jet OLEDB:System database="";Jet OLEDB:Registry
Path="";Jet
OLEDBatabase Password="";Jet OLEDB:Engine Type=5;Jet OLEDBatabase
Locking
Mode=0;Jet OLEDB:Global Partial Bulk Ops=2;Jet OLEDB:Global Bulk
Transactions=1;Jet OLEDB:New Database Password="";Jet OLEDB:Create
System
Database=False;Jet OLEDB:Encrypt Database=False;Jet OLEDBon't Copy
Locale
on Compact=False;Jet OLEDB:Compact Without Replica Repair=False;Jet
OLEDB:SFP=False/w:Udl
w:TableqryCEDS/w:Table
w:SrcP:\MastMail\dbBiState Mastermail.mdb/w:Src
w:FieldMapData