Hi

I've scheduled a DTS job to execute a MS Access Macro. It runs the macro using an "Execute Process Task" and the macro parameters are entered in the parameter field.

Step 1
Win32 Process : C:\Program Files\Microsoft Office\Office\MSACCESS.EX
Parameters : "G:\Database\DB_One.MDB" /x MAC_AutoImport
Step 2
Win32 Process : C:\Program Files\Microsoft Office\Office\MSACCESS.EX
Parameters : "G:\Database\DB_Two.MDB" /x MAC_AutoImport

When I run the DTS job locally it runs fine. There are two steps each executing different Access Macros. Both these macros execute and run to completion. When each step ends the Access database closes

However when the scheduled DTS job runs on the server the process appears to stall at the completion of the first step and the Access DB remains open. When our network administrator closes the DB the job then moves onto the next step. The puzzling thing is that at the completion of the second step the DB closes and the job completes.

We've checked all the permissions/paths/privlidges and believe they are all OK.

If anyone can suggest an alternative I'd greatly appreciate it.

I have read some posts about executing the Macro via a VBScript. Would anyone be able to point me toward example code for doing this

Regards
Ian