I created a batch file called CreateFileofFiles.bat to create a file of files
in the operating system. It contains the following code:

Dir Test*.* > FileTable.txt

It runs successfully from the operating system and I can run it from MS
Access Windows 2000 using the shell command:

Shell ("CreateFileofFiles.bat")

When I try to run the exact same code from MS Access on another computer
which uses Windows XP, it does not create the file. Does anyone have any
ideas? Could it be something unrelated to the fact that it is a different
operating system. I know it is executing the batch command because I put in
a pause in the batch command and I see it pausing, but it will not create the
file. Any help would be greatly appreciated. Thanks in advance.

Try adding the path to the line in the batch file like
Dir Test*.* > c:\FileTable.txt
or do a search for FileTable.Txt

My guess would be that it is being created but not where you think.

Reagrads
Kevin


"RMCompute" <(E-Mail Removed)> wrote in message
news:5EB30CA3-B196-476E-923F-(E-Mail Removed)...
>I created a batch file called CreateFileofFiles.bat to create a file of
>files
> in the operating system. It contains the following code:
>
> Dir Test*.* > FileTable.txt
>
> It runs successfully from the operating system and I can run it from MS
> Access Windows 2000 using the shell command:
>
> Shell ("CreateFileofFiles.bat")
>
> When I try to run the exact same code from MS Access on another computer
> which uses Windows XP, it does not create the file. Does anyone have any
> ideas? Could it be something unrelated to the fact that it is a different
> operating system. I know it is executing the batch command because I put
> in
> a pause in the batch command and I see it pausing, but it will not create
> the
> file. Any help would be greatly appreciated. Thanks in advance.
>

Kevin,

Your guess was right on! It was creating the file in a directory a few
levels up. I coded all of the directory information in the batch file and it
worked fine.

Thank you.

"kc-mass" wrote:

> Try adding the path to the line in the batch file like
> Dir Test*.* > c:\FileTable.txt
> or do a search for FileTable.Txt
>
> My guess would be that it is being created but not where you think.
>
> Reagrads
> Kevin
>
>
> "RMCompute" <(E-Mail Removed)> wrote in message
> news:5EB30CA3-B196-476E-923F-(E-Mail Removed)...
> >I created a batch file called CreateFileofFiles.bat to create a file of
> >files
> > in the operating system. It contains the following code:
> >
> > Dir Test*.* > FileTable.txt
> >
> > It runs successfully from the operating system and I can run it from MS
> > Access Windows 2000 using the shell command:
> >
> > Shell ("CreateFileofFiles.bat")
> >
> > When I try to run the exact same code from MS Access on another computer
> > which uses Windows XP, it does not create the file. Does anyone have any
> > ideas? Could it be something unrelated to the fact that it is a different
> > operating system. I know it is executing the batch command because I put
> > in
> > a pause in the batch command and I see it pausing, but it will not create
> > the
> > file. Any help would be greatly appreciated. Thanks in advance.
> >
>
>
>