Updating users front ends via VBA (1 Viewer)

[Pat Hartman]

The command prompt window should close automatically. I'm not sure why you had to force it to close. What did you add to the script?

 

[tmyers]

The command prompt window should close automatically. I'm not sure why you had to force it to close. What did you add to the script?

start "" "%userprofile%\Desktop\Quotations.accdr"

I just added the start argument to it. Otherwise the command prompt window wouldnt close until you closed Access.

 

[The_Doc_Man]

Ah, that explains it. For those who love dichotomies, there are two ways to start a process under Windows. You can create a child process or you can create an independent process. You wait for children because technically, they are a part of your main process. You don't have to wait for independents because they have a separate life of their own.

 

[Pat Hartman]

Thanks.