Re: DDE Access to Word using mde

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

I have all three(2000,2002,2003) versions of Access and Word.

I am opening Word from an Access procedure as follows:
Set WordDoc = GetObject(WordFileSpec, "Word.Document")

strConnect = "TABLE " & merge_qry
strSql = ""
If (WordDoc.Application.Version > 9#) Then
strSql = "SELECT * FROM [" & merge_qry & "]"
End If

WordDoc.MailMerge.OpenDataSource _
Name:=Datafile, _
ReadOnly:=True, LinkToSource:=True, _
Connection:=strConnect, _
SQLStatement:=strSql

where Datafile is the database name and merge_qry is the table name.

What I found is this:

With Access running as mdb, this works for all combinations.
With Access running as mde:
It works fine with any version of Access and Word 2002.
It works fine with any version of Access and Word 2003 but I currently have
some problem with my installation. I keep getting the old "Encountered a
problem and has to close" message for the 2nd instance of Access that Word
opens. but Word opens just fine.
It does not work with any version of Access and Word 2000. I get the message
originally noted.

What is the OLE DB method that you mentioned? Does it handle memos?

Thanks,
Beth

"Peter Jamieson" wrote:

Here, in the simple case where you have a Word 2003 document and you connect
to an Access 2002/3 .mde using DDE, the connection is fine. Assuming you are
actually launching a mailmerge from Access,
a. how exactly are you doing that?
b. can you try the simpler case and see if that works?
c. which versions of Word and Access are you using? (It sounds like 2000
(which I can't test right now), but if it's 2002/2003 have you tried the OLE
DB connection method as well?)

Peter Jamieson

"Beth" <Beth@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:A5F1E39F-83DC-4CEB-8A7E-999F8E240D6B@xxxxxxxxxxxxxxxx
I would like to give my clients mde files instead of the open source mdb.
However, I need to export reports(mailmerge) to Word and this doesn't seem
to
work with DDE connection. It gives error message "....mde is locked for
editing by another user. Click 'Notify' to open a read-only copy of the
document...." Clicking notify doesn't work either. it hangs and I have to
kill Word throught the task manager.

connecting with ODBC works great! However, ODBC doesn't handle memos and
dates.

By the way there are no other users(except the current opening of the
file)
and this has nothing to do with opening shared or exclusive in the options
menu.

DDE works with mdb but not with mde.

Any suggestions?

Thank you,
Beth

.

Relevant Pages

  • Re: Mass convert to 2007: linked data, mail merge info problems
    ... The only observation I can think of is that DDE has always been rather ... Whether I use it or not, when I open the new 2007 docx, it prompts me ... "Word could not re-establish a DDE connection to Microsoft Access to ... When the user opens the original 2003 doc, ...
    (microsoft.public.word.vba.general)
  • Re: Mail Merge - Parameter prompts twice...
    ... document is already linked to the data source. ... that it will try to make the connection all over again. ... > that will close the Access database that the DDE connection opened? ... > or two later Word opens, and the Confirm Data Source dialog box opens up. ...
    (microsoft.public.word.mailmerge.fields)
  • Re: Word could not reestalish a DDE connection to ACCESS DB
    ... the .mdb /wherever it is/ When the Select Data Source dialog box opens, ... conversion at open" is checked) you should see the DDE option and you should ... When you make a connection to a data source in Word, ...
    (microsoft.public.word.mailmerge.fields)
  • Re: recovery tool
    ... If OE is not opening, its usually due to a corrupt folders.dbx file. ... that and then see if OE opens. ... Because of this tendency of attachments to infect, ... Turn off email scanning in your antivirus software. ...
    (microsoft.public.windows.inetexplorer.ie6_outlookexpress)
  • Re: DDE connection w/ Access & Word 2007
    ... Open the query in Access, supplying the information requested by the ... XP/Office XP using DDE, Access XP opens the .mdb and makes the connection ...
    (microsoft.public.word.mailmerge.fields)