A few weeks ago, I asked the question:
about how to run an .exe (created by FoxPro 2.6) from a button on an Access form.
In response to that question, I'm now using the following code to run these programs:
stAppName = "\\NTSERVER\FOXPRO\FOXPROW
Call Shell(stAppName, 1)
However, with the program in this example (ITMOVTOM.EXE), it immediately fails with the message: "File 'w:\foxprow\invout\bookeep
.dbf' does not exist." The .dbf file is actually on the "F" drive (alias: "\\NTSERVER\FOXPRO")(like the .exe file), not on the "W" drive (alias: "\\NTSERVER\WORKSHET"). However, the Access .mdb file is on the "W" drive.
The .exe file runs fine from a WinXP icon.
Is there anything I can do to make the .exe run from Access without getting confused?
(I asked this question in the Access forum originally, but no one there ever commented on it.)