shell function

  • Thread starter Thread starter Richard
  • Start date Start date
R

Richard

Hi

I am using the shell command to call a vb executable.

Call Shell(\\server\folder\Update.exe)

it copies a mde to replace this current mde.

The problem that it won't work when I call it but it does when I click on
the exe.

What is wrong and how do I overcome this?

Many thanks in advance
Richard
 
Can you post the code you are using the call the shell
and any other info that may affect it
 
Hi

The code is as follows:

If MsgBox("The database will be closed for the process and will open
when it has updated." & vbCrLf & "Press OK to continue or Cancel to Abort",
vbOKCancel, "Update DB") = vbOK Then

Call Shell("\\server\folder\update.bat", vbHide)
DoEvents
DoCmd.Quit

End If

Many thanks
Richard
 
Oh sorry

The code should be an exe instead of bat. I am trying out a batch file, thus
for the bat file I copied.

Richard
 
Back
Top