SHELL command question

[m]

I am using the SHELL command to execute an osql statement
that will run a script file against an SQL database. My
problem is it runs asynchronously. I need a way to wait
for the SHELL command to finish before going on to the
next step.

Any help would be greatly appreciated.

thanks

 

[Paul Overway]

See http://www.mvps.org/access/api/api0004.htm

 

[Tim Ferguson]

I am using the SHELL command to execute an osql statement
that will run a script file against an SQL database.

Why not just do a set of conn.Execute() methods?

Tim F

 

[m]

Can I use the conn.Execute() method to call an external
file that contains the script?