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 dat
abase 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. Wh
y 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 o
n 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. W
hy 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 ?