Problem with Shell from Access

[pgaccess]

Hello Guys,


I'm a new entry in that forum and I haven't so much experience, so I meet a problem with Shell function.
I'll try to explane the situation, I need to execute a dos command from Access 2007, so I wrote as below :

shell ("wmic csproduct get name,vendor > LogFile.log")

when that row is executes the Prompt window flashing for one second and no error for that command but the LogFile.log is missing, if I try to execute the command from Prompt of Dos it works perfectly. Why ?

The work directory is c:\users\pippo\

Please let me know something, thanks in advance.

PG

[ranman256]

put the command into a .BAT file , then shell the bat.

call shell ("c:\runthis.bat")

runthis.bat file:
wmic csproduct get name,vendor > LogFile.log

[pgaccess]

Thank you,
perhaps I have not said everything, I've done as you told me, but my intention is to eliminate every .bat file in order to execute the command when the user runs my access application.
I would like to get the information I need without the user knows and reads this process in the working directory, this should be a gosth process. I hope I have explained my intention possibly without written .bat files in the directory but run Shell commands directly from Access, is it technically possible?

[aytee111]

What about this: Shell "cmd.exe /c <yourcommand>"

[pgaccess]

As you told me I tried to execute this but it doesn't work:

Shell "cmd.exe /c wmic csproduct get name,vendor > Path & LogFile.log"

Path is variable where I put the work directory ...

[aytee111]

1 - does the cmd work in DOS exactly as you typed it above?
2 - does the Shell work without using a variable path?

[pgaccess]

1. No, but when I write the command from access it needs to knows the path because without doesn't work
2. Yes, from prompt of Dos it works if I typed manually the path : cmd.exe /c wmic csproduct get name,vendor > c:\users\pippo\LogFile.log

However I need to execute the command from Access !!! That's the real problem !!!
Please, you Try to write the command into a bat file and run it from Access and let me know your test ...

[aytee111]

1 - No? first get the cmd working in DOS prior to trying to make it work in Access
2 - if it is the path that is causing the problem then find the path in Access prior to running the Shell

[pgaccess]

Perhaps I have explained not so good, forget the path for the moment ...

1. I told you that in DOS this command works : cmd.exe /c wmic csproduct get name,vendor > c:\users\pippo\LogFile.log
2. If I put the following command in ACCESS doesn't works : Shell "cmd.exe /c wmic csproduct get name,vendor > c:\users\pippo\LogFile.log"

Why ? Could you try in your PC ?

[aytee111]

Here's another one that evidently works: Shell "cmd /c echo go>C:textfile.txt"

Sorry, I am unable to try it on my pc.

Another option is to create a temp bat file just before the Shell command, maybe in temp folder, with the command you want, then Shell it, then delete it.

[jwhite]

Hmm... Executing your Shell command in the VB Immediate Window, changing c:\users\pippo to c:\users\jwhite (for my PC), it worked fine. Could it be something like an application permission issue? Is c:\users\pippo set as a Trusted Location in Ac2007? If you changed it to write to c:\temp and created the folder beforehand, does that work?

[pgaccess]

Thanks at all,

I solved as below :

Shell "cmd.exe /c wmic csproduct get name,vendor >" & Path & "LogFile.log"

Now I can execute the shell from Access defining the path as I want, reading the LogFile.log e after erase the LogFile.log without that user see that process and the .log file ....

Wow !!! Thanks again !!!

[aytee111]

Well done! (Not sure how much help we were!)

[jwhite]

We both overlooked sample string in post #5 - the variable is within the quoted string to execute.