Word crashes when link Access via OLE

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

From: Grace (gaasen_at_dhs.ca.gov)
Date: 07/14/04 

Date: Wed, 14 Jul 2004 09:31:28 -0700

I have tried to link to various Access databases with old
and new Word merge files via the default connection -
OLE. Whenever I do this, Word says that it needs to
close. It crashes whenever I try to link to the database.
This only started happening in the last couple of months.
Does anyone know why?

I tried connecting via DDE and that appears to work fine.
Is there a downside to using DDE instead of OLE?

FYI, I'm running WindowsXP and Office 2002.

Thanks,

Grace

Relevant Pages

  • Re: Access/Word 2007 Mail Merge
    ... DDE connection working properly and thus the right dialog box is now showing ... Looking over everything again it appears that you are right - the OLE DB ... This isn't quite what I normally see either: Queries with joins are ...
    (microsoft.public.word.mailmerge.fields)
  • Re: DDE Access to Word using mde
    ... OLE DB is the method that Word 2002/2003 use by default - in fact, given the code you are using, I am pretty sure that when your Access code opens the word document in Word 2002/2003, Word will be using OLE DB rather than DDE to open the data source. ... So either the OLE DB connection is handling your dates and memos just fine, or I'm wrong and DDE is being used. ... ODBC should get your dates OK, but you would need to use switches in the Word fields to format them correctly. ...
    (microsoft.public.word.mailmerge.fields)
  • Why DDE connection?
    ... I am doing a mailmerge from Access (2000 format) to Word ... and the connection is using DDE instead of OLE, ... doesn't have any imbedded DDE connections. ...
    (microsoft.public.office.developer.automation)
  • Re: Migrating Problem Word 2000 to Word 2003
    ... > new table and then getting the data form this newly created table?? ... You can only link to queries containing user-defined functions using a DDE ... OLE DB connection. ... And OLE DB connections were introduced in Word2002; ...
    (microsoft.public.word.mailmerge.fields)
  • Re: ODBC/OLE DB Connection Pool
    ... but most OLE DB providers are. ... OLE DB provider indicates is supports a Free Threaded model ... >> connection be kept open for the application as this will serialize all ... >> The ADO Connection object implicitly uses IDataInitialize. ...
    (microsoft.public.data.ado)