Running SQL Server job from Access

[Guest]

I rewrote several Access programs to run as a single SQL stored procedure on
SQL Server. A job created in DTS executes the SQL stored procedure. This
job is executed from a batch file as listed below:
.......
Dim RetVal
Dim strPathFile
strPathFile = "C:\BTExe.cmd"
RetVal = Shell(strPathFile,1)
........
As soon as the code is submitted it returns the return value. Is there any
way to have the job operate as if it was being run within Access ? For
example, display the hour glass until the job completes. Is there a
recommended procedure to run jobs from Access on SQL server, which prevents
the user from using the system until the job completes ?

 

[Douglas J. Steele]

Take a look at http://www.mvps.org/access/api/api0004.htm at "The Access
Web" for how to have your code pause until the Shelled program has
completed.

 

[Guest]

Thank you. (This system no longer lets me rate the reply).