Shell command in Access Module dos not work on Windows 64 machine

S

Scott

I have an application in Access 2003 that works fine on a windows 2000
server. Users access the application through terminal services. One feature
of the application is using a Castelle Box for faxing information from the
Access app. This is accomplished using Shell() in VBA fax via the Castelle
Box (it came with a command line submitfax.exe). Now I am moving the
application to a Windows 2003 Server x64 and many things are working but the
submitfax.exe provided by the Castelle cannot be installed on the x64 (unless
I upgrade to a Castelle product with features I do not need and costing 10
times as much as the one I have). So to temporarily solve this problem I use
terminal services FROM the 2003 x64 server to connect to the old 2000 server
and run submit fax there. I am able to automate this with .bat and cmd files
as well as .rdp files with the connection information. Howver when I try to
do this from within a VBA module I either get mstsc.exe (the Remote Desktop
Connection) is not found or the .rdp file opens in notepad instead of running.


Help
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top