Hi Everybody,


Im trying to run a foxprow 2.6 exe from MSAccess. Im using some WIndows API functions (WaitforSIngleObject ) and I encountered this problem :when running DOS programs ,I am able to "catch" the moment when those programs finish whereas when running the foxpro for windows , the program runs asynchronously and access doesnt wait for it to finish. Is there anyway I can run the foxprow 2.6 exe program so that I know when it finishes?

Also I am wondering if there is any way I can transfer objects( tables,stored procedures etc) between 2 sql server databases by automation in access.

Thank you ,

Vlad