I have a simple DTS Package that truncates a table and then imports records
from an Access database into the table. I am connectiong to the Access db
using the Admin user. The package works when manually run. But when I
schedule it as a Job, I get an error stating that the Jet Db Engine can not
open the file as its already opened exclusivly or you need permissions to
view its data. What is it about a job that changes how a connection is being
made to the Access db? I have tried creating a sql user named "Admin" and
making him the owner of the job, but that didn't help. I am using SQL2000
and the Access db (97) is located on a shared drive on a server using Windows
2000.

And suggestions would be greatly appriciated!

A job is slightly different and this article explains things

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

--
--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.konesans.com - Consultancy from the people who know


"Bruce" <Bruce (AT) discussions (DOT) microsoft.com> wrote