Running a program from access to open in a particular folder

[Isissoft]

I have been haveing trouble runing an external program from Access and
having it open in a particular folder.

I thought the answer was to use the program shortcut as you can specift
which folder to start in when using a program shortcut - Barry kindly gave
me a shell execute function that does run the shortcut from Access but it
always opens in the folder that the access database is in. Is there any
other way of achieving what I need to do ?

Thanks for any help - and thanks for the shellexecute function Barry.

 

[Bob Hughes]

I have been haveing trouble runing an external program from Access and
having it open in a particular folder.

I thought the answer was to use the program shortcut as you can
specift which folder to start in when using a program shortcut - Barry
kindly gave me a shell execute function that does run the shortcut
from Access but it always opens in the folder that the access database
is in. Is there any other way of achieving what I need to do ?

Thanks for any help - and thanks for the shellexecute function Barry.

Have you by any chance tried the chdir function before running the program?
Bob