> Hi,
>
> this is a problem I have some longer period, so I will rephrase my
> question.
>
> I have done lots of testing, learnt some things but still do not have a
> solution for my problem.
>
> Here it is:
>
> MS SQL server 2000
> I have created DTS package to copy from MS Access 2000 database to SQL
> table.
> Access database is local, but table is linked to another Access database,
> physicaly on network, on antoher machine.
> DTS package is running OK, but scheduled as job is constantly failing.
> databses are used through workgroup file.
>
> I have set up file location in registry
> I did it on both machines
> I created access username as server name (for SQL job agent to understand)
> but it is still not working for linked table.
>
> error on scheduled job is:
>
> DTSRun: Loading... DTSRun: Executing... DTSRun OnStart:
> DTSStep_DTSDataPumpTask_1 DTSRun OnError: DTSStep_DTSDataPumpTask_1,
> Error
> = -2147467259 (80004005) Error string: The Microsoft Jet database
> engine cannot open the file 'T:\vr.mdb'. It is already opened exclusively
> by
> another user, or you need permission to view its data. Error source:
> Microsoft JET Database Engine Help file: Help context:
> 5003051
> Error Detail Records: Error: -2147467259 (80004005); Provider
> Error:
> -534709256 (E020FBF8) Error string: The Microsoft Jet database
> engine
> cannot open the file 'T:\vr.mdb'. It is already opened exclusively by
> another user, or you need permission to view its data. Error source:
> Microsoft JET Database Engine Help file: Help context:
> 5003051
> DTSRun OnFinish: DTSStep_DTSDataPumpTask_1 DTSRun: Package execution
> complete. Process Exit Code 1. The step failed.
>
>
> The same is hapenning with comand line rundts, runs ok, but when scheduled
> in windows scheduler it fails.
>
> Does anyone have any ideas where to look for the answers.
>
> The last conclusion I have is that linked or network access tables are
> proble, but only when scheduled as jobs.
>
> TIA