Re: Scheduling a Job on a Locked Access DB

Hello Brian,

This could well be because you do not have permissions when running as a job. Not only will your Agent/Proxy account need perms to the DB but it may also need perms onto the location of the ldb lock file.

Have a read of this

http://support.microsoft.com/?kbid=269074


Allan

Hi All,

We have a 3rd application that writes data to an Access database every
hour. I wrote a DTS package to import this data just after the data is
written. The package works fine when it's run in standalone mode (ie:
executed manually), but when I schedule the package, I get the
following error:

Executed as user: SPSHR\SYSTEM.
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.  Process Exit Code 1.  The step
failed.
Is there a way to force the DTS package to ignore the open status of
the database in order to read the data?

Thanks,

Brian.



.

Relevant Pages