I have a dts package that is copying over data from sql server to MS
access. The package runs fine when run from enterprise manager.
However fails when I run it using dtsrun if the access database is
open with the following error (see below).
Can I run the package using dtsrun while the access is still open?
Any help will be appreciated.
Thanks.

DTSRun: Loading...
DTSRun: Executing...
DTSRun OnStart: DTSStep_DTSDataPumpTask_1
DTSRun OnError: DTSStep_DTSDataPumpTask_1, Error = -2147467259
(80004005)
Error string: Could not use ''; file already in use.
Error source: Microsoft JET Database Engine
Help file:
Help context: 5003045

Error Detail Records:

Error: -2147467259 (80004005); Provider Error: -67044352 (FC00FC00)
Error string: Could not use ''; file already in use.
Error source: Microsoft JET Database Engine
Help file:
Help context: 5003045

DTSRun OnFinish: DTSStep_DTSDataPumpTask_1
DTSRun: Package execution complete.
NULL