Re: running a perl script via Shell() in MS-Access

I think it could be a problem of current directory. Make sure Access' CurDir is where your script is before you attempt the above, or use a fill path for the script.

Comment on Re: running a perl script via Shell() in MS-Access

Replies are listed 'Best First'.
Re: Re: running a perl script via Shell() in MS-Access by aquarium (Curate) on Jul 04, 2003 at 00:07 UTC
..and make sure your perl5.8.0.exe is in path	[reply]
Re: Re: Re: running a perl script via Shell() in MS-Access by Grygonos (Chaplain) on Jul 04, 2003 at 03:56 UTC
I had the file in the same dir as the db.. and perl is in the path. I found out that using the START command opens a file using its associated program .. it worked fine... ill post the crappy vb code to do it monday...	[reply]
Re: Re: Re: Re: running a perl script via Shell() in MS-Access by aquarium (Curate) on Jul 07, 2003 at 01:13 UTC
found it me thinks...seems to work by having silly Microstiff quoting like so: `stAppName = """D:/Sirsi/Perl/Bin/perl5.6.0.exe"" " + " c:/work/abc.pl" Call Shell(stAppName, 1)` [download] Hope it works for you now	[reply] [d/l]