Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

Turn off dde for access 2003 in server 2008

Posted on 2010-11-25
16
Medium Priority
?
2,269 Views
Last Modified: 2013-11-29
I'm getting the "There was a problem sending the command to the program" error when running an access 2003 database from the desktop on a server 2008 terminal server. I have checked and unchecked all the combinations on the advanced tab of the database and cannot get the message to go away. Where do I get rid of the dde process in this environment. On server 2008 the folder options, file association tab doesn't look like the older versions where you have a dde option. I guess it's somewhere in the registry, but I can't for the life of me find out where to go.
0
Comment
Question by:breauxlg
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 8
  • 3
  • 2
16 Comments
 

Author Comment

by:breauxlg
ID: 34227518
Thanks.
0
 
LVL 85
ID: 34430630
Do you get this error while you're performing any specific task - for example, does it occur when you Open a Form, or when you enter data in a control, etc etc?

Have you performed maintenence on the database (i.e. Compact, Compile, Decompile, etc)?

0
 

Author Comment

by:breauxlg
ID: 34430660
The database basically just opens, runs a procedure, and closes. The prodecure runs and performs the intended function, but the message still appears. After clicking OK, it goes away, but it confuses the users to have that message pop up evertime the database runs. Thanks for caring enough to respond, by the way.
0
10 Questions to Ask when Buying Backup Software

Choosing the right backup solution for your organization can be a daunting task. To make the selection process easier, ask solution providers these 10 key questions.

 

Author Comment

by:breauxlg
ID: 34430664
I have tried decompiling and recompiling, compacting and repairing, etc. to no avail.
0
 
LVL 85
ID: 34430679
What's the procedure? What does it do?
0
 

Author Comment

by:breauxlg
ID: 34519108
It just copies a front-end database to the desktop of the user.
0
 
LVL 85
ID: 34520263
Can you post the code that causes the error?
0
 

Author Comment

by:breauxlg
ID: 34536892
Here's the little database that generates the error. It does not generate the error on Server 2003.  BackupLoadWorks.zip
0
 
LVL 1

Expert Comment

by:jbodager
ID: 34548060
try going to this registry key:  HKEY_CLASSES_ROOT\Access.MDBFile\shell\Open\ddeexec

change the key name "ddeexec" to "NOddeexec".

I had a very similar problem and it fixed my issue.  My co-worker helped me with this issue.  We found that the ability to turn off DDE in Access was removed in current versions of windows, so you need to go into the registry to do it.  changing "ddeexec" to "NOddexec" is kink of a hack, but it worked.

good luck.
0
 

Author Comment

by:breauxlg
ID: 34557444
jbodager - There is no key in the registry at that point. I don't have Access.MDBFile under HKEY_CLASSES_ROOT. That looked hopeful, though.
0
 
LVL 1

Accepted Solution

by:
jbodager earned 2000 total points
ID: 34595605
0
 

Author Comment

by:breauxlg
ID: 34604410
I found the access.application registry entry and renamed the ddeexec to noddeexec and the message went away. Thanks jbodager.
0
 

Author Closing Comment

by:breauxlg
ID: 34604418
I'm just glad someone was still looking at my problem. Thanks.
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Microsoft Access is a place to store data within tables and represent this stored data using multiple database objects such as in form of macros, forms, reports, etc. After a MS Access database is created there is need to improve the performance and…
After seeing many questions for JRNL_WRAP_ERROR for replication failure, I thought it would be useful to write this article.
In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …
Suggested Courses

722 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question