Thank you for your idea. I will try it.
>>Hello!
>>
>>I am looking for a way to run Access from VFP. Here's the situation in a nutshell:
>>
>>I have a VFP app minimized to the system tray doing several things, one of which will (hopefully) be to fire up an Access application which performs an import without user intervention, then quits on its own. I just have to run Access and pass it a few parameters and away it goes.
>>
>>From the Start->Run menu, it works great, but I cannot find a way to get it to work from VFP without the DOS shell. Using the RUN or ! command does not handle the parameters correctly that I pass.
>>
>>Anybody out there do something similar that can help me out?
>>
>>JL Miller
>>Logikos, Inc.
>>"Desperate In Houston"
>
>You may create a macro that does the import and invoke Access as a server like so:
>oAcc=CreateObject("Access.Application")
>oAcc.DoCmd.RunMacro("ImportMacro")
>Also, you can execute several other methods from the application object to accomplish the same task. But a macros may be the quick way to do it.HTH
John L. Miller
Logikos, Inc.
"Solutions With Software"
Tel: 979-826-6034
Fax: 979-826-8845