RunApp IN Access

[Datahead2010]

Trying to call a SSIS loader to fill some tables. If I use XP I can go to "Start", "Run", and place the loader's name and path, it runs fine, When I try to call this same thing via a MS access macro with RunApp I get the error: "Microsoft Access can't invoke the application using the Run App action. I did verify the path. Any ideas?

 

[spikepl]

Show the EXACT text you typed in Run and also the one you supplied in the macro

 

[Datahead2010]

Thanks I did that, that is how I got it working here it is:

"C:\Program Files\Microsoft SQL Server\90\DTS\Binn\DTExec.exe" /file C:\Temp\sheet2_loader.dtsx

 

[spikepl]

Double quotes around paths with spaces in them ...