[AccessD] Launching a dos program from Access 97

Hi Tim

Just guessing ... create a batch file that will launch and run the application.
You may need to use CD to make the folder of the app the current folder.
When success with this, use Shell() to launch the batch file.

If that fails, try with a shortcut or pif file.
Also, you may try using Shell() with the START command. Type START /? on the command line for help on this.

/gustav

>>> boogieloogie at gmail.com 26-02-2006 22:23 >>>
Hi Gustav

I should have explained myself a bit better. The particular program will not
fire by using

Dim ProgLaunch
ProgLaunch = Shell("C:\fmv\prethin.exe", 1) will crash it. For some reason
certain files are not fired when starting this way. I have no access to the
code nor the programmer of the dos program.

Some how I have to fire c:\windows\system32\cmd.exe change to the fmv folder
then launch prethin.exe from there.

Any ideas?

Thanks

Tim

I have to launch it from within the dos window. I do not know how to do this
On 2/25/06, Gustav Brock <Gustav at cactus.dk> wrote:
>
> Hi Tim
>
> Look up the Shell() function ... it is exactly for this purpose.
>
> Remember, if path contains spaces it must be wrapped in double-quotes, and
> full filename must be used (.exe).
>
> /gustav
>
> >>> boogieloogie at gmail.com 25-02-2006 17:12 >>>
> I have a client using an old DOS program called prethin.exe. It is in a
> folder called fmv. I do not need to pass any variables to it. Just need it
> to lauch after I feed data to the underlying dbf's. Is it possible to
> launch
> it with some vba code behind a button in Access 97? Anyone have a sample?
>
> Thanks
>
> Tim