Access 2003 - There was a problem etc

[PiedPiper70]

I frequently get the error message "There was a problem sending the command to the program" but despite searching repeatedly I cannot understand it or solve it, yet it appears to be common. So I'm putting it on here to see if anyone here can help.

I have an application written in Access 2003 that has run perfectly well for years on an XP machine. It's a standalong little app that is started by the scheduler and shuts itself down when finished.The 'app' creates a table, populates it with data and lastly produces a csv file.

I'm now running this on a Windows 7 64 bit machine and now I see the above error pop up when the app completes. Not every time - but frequently. Also running on Server 2008 - same issue. I think it's connected with the csv creation part but that's just a guess.

In the near future we are converting to Office 2010 and I presume that will be the end of my problems. But in the meantime..... can anyone help me with a solution.

Thanks
Dave

 

[CJ_London]

Are you using API's? and are you running 64 bit Office

If so you need to add PtrSafe into the call:

Public Declare PtrSafe Function....

 

[PiedPiper70]

No API's and it's 32 bit.

But thanks for trying

 

[CJ_London]

Found this link which might provide a clue since you think it may be linked to .csv creation

http://answers.microsoft.com/en-us/...d-to-the/56ee1743-b476-43a5-9b00-169b8c6ef37a

Also, another simple suggestion if not already tried - have you recompiled the code and compacted - might shake a few bugs out!

 

[pr2-eugin]

What is the command you are trying to use?

 

[PiedPiper70]

Here's the line:-

DoCmd.TransferText acExportDelim, "", "tblTemp_Requests", "m:\lcs\kram\lcs-req.csv", False

 

[PiedPiper70]

Found this link which might provide a clue since you think it may be linked to .csv creation

http://answers.microsoft.com/en-us/...d-to-the/56ee1743-b476-43a5-9b00-169b8c6ef37a

Also, another simple suggestion if not already tried - have you recompiled the code and compacted - might shake a few bugs out!

Thanks for the link. I had seen that but mostly about Word. I hadn't noticed it was 5 pages though so I'll give it a more thorough reading.

Decompile/recompile etc made no difference

 

[PiedPiper70]

Coorrection - I don't think it's the CSV creation after all. 2 reasons

1. I tried a home made function to create the csv but that didn't help

2. I tried commenting out the whole csv bit - and that didn't help either !!

"hangs head in shame"

 

[PeterF]

In Excel under Windows 7 I had similar messages. Uncheck DDE solved my problem then.
See: http://support.microsoft.com/kb/211494

 

[KirkComer]

Did you ever find a solution to your problem? I have the same problem. Unchecking the DDE checkboxes did not help. If I run the access database from my desktop (or anywhere else) by clicking on it normally I get the error message. If I hold the shift key when opening the access database I do not get the error. Any help is greatly appreciated!

 

[PiedPiper70]

Not solved so far unfortunately.

If there was a clear explanation of how to solve this for Access 2003 under Win 7 64 bit using the registry then I make be prepared to give it a go but nothing I've seen so far looks very convincing.