User Permission

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to give the users of my database the ability to run reports off
it. At the same time, I dont want them to be able to view my queries/tables.
I gave the 'permission' to one of my users to open a report but not the
permission to open an underlying query or table. Then I logged in as that
user to test it out. I tried to run the report and it gave the following
message:
"Record(s) cannot be read; no read permission on <name>. (Error 3112)"
I then gave this user the permission to view queries and tables. The user
was then able to run the report.
From this, it seems that I cant withhold tables and queries from a user's
view without disabling the user fronm running reports also. Is there a way to
accomplish what I am trying to, that is give my users the ability to run
reports without letting them view queries/tables
 
neeraj said:
From this, it seems that I cant withhold tables and queries from a
user's view without disabling the user fronm running reports also. Is
there a way to accomplish what I am trying to, that is give my users
the ability to run reports without letting them view queries/tables
Click to expand...

Users need Read Data/Read Design on the recordsource for the report. You
don't need to give them permissions on the tables at all, if the
recordsource is a query, and if you set the query to 'run with owner
permissions' (you'll see that in the properties dialog for the query).

You can hide the db window, so they can't get directly to the
queries/tables/etc.
 
If I were to hide the entire database window by going to
Tools-Startup-unchecking 'Display Database window' , my users would not even
be able to see the form that allows them to select the report that they would
want to run?
 
Well you would provide a switchboard type form that allows them to navigate
around your application (launch forms and reports, enter criteria, etc).

Just create an unbound form with buttons to open the various forms.

Actually, if you just have one form, then make that the one to open on
startup (Tools, Startup).
 
Even if I were to provide a switchboard form, my users can always press F11
to get to the database window and then be able to access queries. Any way to
prevent them from doing that?
 
There are a number of things you can do:

Create custom menus/toolbars for use throughout your application.
Create a startup form (a main menu form if you have one) that is opened on
startup.
Use the features in Tools, Startup to
set the startup form
set your default menu (the custom one you made)
disable all the checkboxes about allowing built in menus, toolbars,
changes etc.
hide the db window (ensure the custom menu you create does not
include the Windows, Unhide item)
Click on the Advanced button and uncheck the allow special keys
(this will disable the F11 key, among others)

If you need to bypass these startup features, you can hold the shift key
down while you open the db. If you feel that your users may use this to
bypass your settings, you can disable the shift key bypass - there's an
example in help for doing this(look for AllowBypassKey) or at
http://www.mvps.org/access/modules/mdl0011.htm
and
http://www.mvps.org/access/general/gen0040.htm

You can also create a MDE from your database, which will prevent changes to
forms, reports and modules (If you do this, be certain to keep your original
mdb in case you need to make changes).
 
Back
Top