>I don't think you can run application with GUI this way.
Even though the program is written in VB - there is no user interaction - the app starts, does its thing, then closes. What would the difference be if I wrote a VFP prg and compiled in to an exe? It still wouldn't run using xp_cmdshell, would it?
>
>>>I think the problem is in the spaces in the dir name. Try
EXEC xp_cmdshell '"C:\Program Files\CU Solutions\Car2\car2.exe"'
>>
>>Thanks - I just tried that - the 'query' ran for a minute and then I stopped it - the program did not start. The exe in question is a VB exe.
>>
>>When I go Start/Run and then type in "C:\Program Files\CU Solutions\Car2\car2.exe" - the program starts right away. There must be something missing in the SQL query code.
>>
>>
>>>
>< snip >
Al Williams
Anola MB, CANADA