over the entire folder where the databases resides.
same.
Thank you Darren for the answer.
>-----Original Message-----
>In article <003f01c3551c$81810f30$a301280a@phx.gbl>,
masfer
><m.ferraresi@cribisnetgroup.com> writes
>>I get this error when i try to schedule a DTS with a
proxi
>>account that is member of the local "power users" group:
>>---------------------------------------------------------
-
>>DTSRun: Loading... DTSRun: Executing... DTSRun
>>OnStart: DTSStep_DTSCreateProcessTask_1
>>DTSRun OnFinish: DTSStep_DTSCreateProcessTask_1 DTSRun
>>OnStart: DTSStep_DTSDataPumpTask_1
>>DTSRun OnError: DTSStep_DTSDataPumpTask_1,
>>Error = -2147467259 (80004005)
>>Error string: Unspecified error
>>Error source: Microsoft JET Database Engine
>>Help file:
>>Help context: 5000000
>>Error Detail Records:
>>
>>Error: -2147467259 (80004005);
>>Provider Error: 0 (0)
>>Error string: Unspecified error
>>Error source: Microsoft JET Database Engine
>>Help file:
>>Help context: 5000000
>>DTSRun OnFinish: DTSStep_DTSDataPumpTask_1
>>DTSRun: Package execution complete. Process Exit Code
>>1. The step failed.
>>---------------------------------------------------------
-
>>
>>If i put the user into the Administrators group, the job
>>goes fine.
>>Can anyone help me???
>>Thanks in advance.
>>
>>Massimo Ferraresi
>>m.ferraresi@cribisnetgroup.com
>>
>
>Check that the user has permissions to write in that
folder where the
>mdb sits.
>
>Jet likes to write a new file for locking, the ldb file,
so read only
>access will not normally suffice.
>
>--
>Darren Green (SQL Server MVP)
>DTS -
http://www.sqldts.com >
>
>.