<cityboy3@yahoo.com> wrote:

>Yes, it does.
>
>
>Arnie Rowland wrote:
>> Does the account SQL Server runs under also have file privileges?
>>
>> --
>> Arnie Rowland, Ph.D.
>> Westwood Consulting, Inc
>>
>> Most good judgment comes from experience.
>> Most experience comes from bad judgment.
>> - Anonymous
>>
>>
>> "cityboy" <cityboy3@yahoo.com> wrote in message
>> news:1153938101.709097.52900@h48g2000cwc.googlegroups.com...
>> > thanks for the reply. I had temporarily given all users all rights to
>> > that folder and all files in it. Nothing changed.
>> >
>> >
>> > Arnie Rowland wrote:
>> >> The mdb file is just a file system file. Check to see if OS file
>> >> permissions
>> >> may need to be adjusted to allow READ/WRITE privileges. to the file and
>> >> perhaps even to the folder.
>> >>
>> >> --
>> >> Arnie Rowland, Ph.D.
>> >> Westwood Consulting, Inc
>> >>
>> >> Most good judgment comes from experience.
>> >> Most experience comes from bad judgment.
>> >> - Anonymous
>> >>
>> >>
>> >> "cityboy" <cityboy3@yahoo.com> wrote in message
>> >> news:1153936506.808883.254840@p79g2000cwp.googlegroups.com...
>> >> >I am new to the linked server concept and I'm having trouble with the
>> >> > following scenario:
>> >> >
>> >> > Users are trying to run a report from Reporting Services whose data is
>> >> > supplied from a stored procedure. The stored procedure gets its records
>> >> > from 2 sources. One is a regular SQL Server table. The other is an MS
>> >> > Access mdb that resides on the c: drive of the same server. In order
>> >> > for the stored procedure to work, I had to set up the Access mdb as a
>> >> > Linked Server.
>> >> >
>> >> > When I run the report with my administrative rights, everything works
>> >> > fine. However, regular users get an error and my testing reveals that
>> >> > it's related somehow to the security on that linked server.
>> >> >
>> >> > I've made sure that all users have rights to the mdb file. I've also
>> >> > tried various property settings in the Linked Server Security
>> >> > properties. The documentation isn't very helpful. Any help will be
>> >> > greatly appreciated.
>> >> >
>> >> > thx
>> >> >
>> >