Error string: The Microsoft Jet database engine cannot open the file '\\myServer\myShare\myPath\myAccessDatabase.mdb'. It is already opened exclusively by another user, or you need permission to view its data. --- I want to wrap the DTS call within a stored proc so that the execution can be controlled via a web page.
I have tried adding the users: sql service and sql reporting service as well as sql admins and sql users and give read permissions in the Access file I want sql server to read but the error is the same, do you know how can I get hold of the user name of the sql process trying to read the Access file?
Can not execute DTS from query analyzer
Posted - 10/05/2006 : 16:40:32
