Re: Linked Server Security question

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@xxxxxxxxx> wrote in message
news:1153936506.808883.254840@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
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



.

Relevant Pages

  • Re: Creating a report entirely through code
    ... but most developers backup the front ... end mdb file before making any significant change (including ... button doesn't gray out after a compile, a control starts to ... No, I'm worried about the module, form and report objects ...
    (microsoft.public.access.formscoding)
  • Re: Combo box lookup and Command button to print report gives ErrorMessage3211
    ... Rather than try to straighten out this code, does anyone have code that lets a person choose a record from a combo box on a form, then print a report based on data the combo box shows. ... with the database closed check the folder that the ... Is there an ldb file with the same name as the mdb file? ... could it be that having the combo box DLookup and command ...
    (microsoft.public.access.formscoding)
  • Re: A really really simple report
    ... An Access MDB file can be located almost ... You generally see the 'database window' when you ... With regard to 'Saving the Query as a report', that's not quite what it does ...
    (microsoft.public.access.gettingstarted)
  • Re: Relationship between MDB file size and amount of VBA used
    ... FYI The forms and report take up a most of the additional ... after verifying that the back up copy is good, Compact the ... database and then continue developing your application. ... Is there a way to determine what part of my MDB file is being the memory hog? ...
    (microsoft.public.access.modulesdaovba)
  • Printing Problems from form
    ... There is only an option to change the printer, not the printer margins ... The APIs for Access 2002-03 are not backward compatible with 2000. ... mdb file or else the changes to the report would not be saved. ...
    (microsoft.public.access.formscoding)
Loading