I have stored procedure that uses the xp_cmdshell procedure to use the dts run to run some dts packages. This package exports data into an Access 97 database. When I run it I get this error:
Error: -2147467259 (80004005); Provider Error: -533791822 (E02EFBB2)

Error string: Could not update; currently locked by user '(unknown)' on machine ''.

Error source: Microsoft JET Database Engine

Help file:

Help context: 5003218

If I right click on the local package and select execute it runs with no problem. Any ideas what is going on?