Waiting for MSAccess to execute DDE commands

[BAC]

Win 2000 Pro, Office 2000 Pro SP3

I submitted this earlier this month (12/8/05) and managed to get the DDE
interface working again by un-installing and re-installing Office 2000, SP3
using the "Run all from my computer" option.

Well it worked for a couple of days, but now I'm getting this error for both
Excel and Access and the Word mail merge document just hangs. I can get into
the data source Access querry and the Excel workbook/spreadsheet. I can run
the query in Access.

I've un-installed and re-installed twice (the second time I rebooted between
the un-install and re-install -> something I didn't think necessary the 1st
time, but when the 1st re-install didn't work I figured what the heck!)

I have A LOT of Access-> Excel integrated apps that are falling apart
because, apparently Access is not talking to Excel, and word is apparently
not talking to either Access or Excel...

I work on a very large corporate network, and the IT types are constatntly
loading hotfixes and upgrades "behind the scenes", but they can't seem to
find any "connection" between my problems and their downloads. I am not teh
only one having these problems, but I do know that not many folks in my area
use DDE and VBA and it may be a local thing..

Any suggestions on configuartion settings or some such that may cause this??
Encryption software, maybe??

I really need help here and the local boys ain't gettin' it!

TIA
BAC

revious Post:

Can you convert the query to a make table query and then use that table as
the datasource.

--
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

 

[Cindy M -WordMVP-]

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

As far as I know, there's not a lot you can do when DDE basically stops working
on a system. The few Knowledge Base articles at Microsoft.com basically say
"use something other than DDE". As far as I've ever been able to determine, the
problem seems to be at the WINDOWS, not the Office level.

As far as Access<->Excel goes: any reason you're not using an ODBC connection
for that (MS Query, basically)?

ODBC would also be a possibility for mail merge, but you'd have to get rid of
the parameter query and filter the records at the merge end, instead.

Win 2000 Pro, Office 2000 Pro SP3

I submitted this earlier this month (12/8/05) and managed to get the DDE
interface working again by un-installing and re-installing Office 2000, SP3
using the "Run all from my computer" option.

Well it worked for a couple of days, but now I'm getting this error for both
Excel and Access and the Word mail merge document just hangs. I can get into
the data source Access querry and the Excel workbook/spreadsheet. I can run
the query in Access.

I've un-installed and re-installed twice (the second time I rebooted between
the un-install and re-install -> something I didn't think necessary the 1st
time, but when the 1st re-install didn't work I figured what the heck!)

I have A LOT of Access-> Excel integrated apps that are falling apart
because, apparently Access is not talking to Excel, and word is apparently
not talking to either Access or Excel...

I work on a very large corporate network, and the IT types are constatntly
loading hotfixes and upgrades "behind the scenes", but they can't seem to
find any "connection" between my problems and their downloads. I am not teh
only one having these problems, but I do know that not many folks in my area
use DDE and VBA and it may be a local thing..

Any suggestions on configuartion settings or some such that may cause this??
Encryption software, maybe??

I really need help here and the local boys ain't gettin' it!

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