I have created a package and saved it under maintenance plans.

The package executes as user NT AUTHORITY\NETWORK SERVICE.

However I am trying to connect to a share on another server and I keep getting the error:

The Microsoft Jet database engine cannot open the file '\\ServerName\Access databases\DB_SQL.mdb'. It is already opened exclusively by another user, or you need permission to view its data."

The database is not opened or exclusive.

I am trying to move our DB's from SQL Server 2000, to 2008.

Looking at the package on 2000, the package runs as admin and this admin account has access to the share.

Can I change the Execute As so it runs as the admin account as I hope this will make the difference?