servers

Hello everyone. Hopefully you can guide me to a solution.
In SQL Server I have a linked server created which links to an MS Access database on our network (same physical server machine actually). I have a view which retreives data from this linked server. My problem is this: only users who have write access to t
he directory where the MS Access database is located can run the queries. Why do they need write access to the directory where the mdb file is when all I am doing is reading data from a table in that mdb ?
Because it is required for Access to manage the .ldb file that holds
locks on the data. Move the mdb to a separate location where you can
grant the necessary ACLs without jeopardizing security or do away with
the Access linked server entirely (I'd recommend the second option).
--Mary
On Wed, 28 Jul 2004 12:36:06 -0700, "Dave at GCP" <Dave at
GCP@.discussions.microsoft.com> wrote:

>Hello everyone. Hopefully you can guide me to a solution.
>In SQL Server I have a linked server created which links to an MS Access database on our network (same physical server machine actually). I have a view which retreives data from this linked server. My problem is this: only users who have write access to
the directory where the MS Access database is located can run the queries. Why do they need write access to the directory where the mdb file is when all I am doing is reading data from a table in that mdb ?