Shell Command Problem (Access 2002)

[robboll]

I have a batch file (RunFiles.bat) as follows:

Dir C: *.* /s > C:\AllFiles.txt

It copies all directories and subdirectories to a text file in the C:\
drive called AllFiles.txt

When I run RunFiles.bat by double-clicking it in Windows XP or running
it from Start->Run->C:\Runfiles.bat ...

....it creates the file AllFiles.txt with
233534 File(s) 44,990,114,384 bytes

However, when I run it with the following Shell Command in
Access:

Shell("C:\windows\system32\cmd.exe /c c:\RunFiles.bat", 1)

....it creates the file AllFiles.txt with only
676 File(s) 241,476,508 bytes

Any ideas on how to deal with this one? Thanks for any help.

RBollinger

[Douglas J. Steele]

I think your batch file needs to be:

Dir C:\*.* /s > C:\AllFiles.txt

On the other hand, take a look at what Randy Birch has at
http://vbnet.mvps.org/code/fileapi/r...es_minimal.htm for how to use
APIs to do the same thing. Yes, it looks much more complicated, but you only
need to copy and paste, and it's very fast.

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)

"robboll" <ro*****@hotmail.com> wrote in message
news:11*********************@o13g2000cwo.googlegro ups.com...

I have a batch file (RunFiles.bat) as follows:

Dir C: *.* /s > C:\AllFiles.txt

It copies all directories and subdirectories to a text file in the C:\
drive called AllFiles.txt

When I run RunFiles.bat by double-clicking it in Windows XP or running
it from Start->Run->C:\Runfiles.bat ...

...it creates the file AllFiles.txt with
233534 File(s) 44,990,114,384 bytes

However, when I run it with the following Shell Command in
Access:

Shell("C:\windows\system32\cmd.exe /c c:\RunFiles.bat", 1)

...it creates the file AllFiles.txt with only
676 File(s) 241,476,508 bytes

Any ideas on how to deal with this one? Thanks for any help.

RBollinger