Re: User Permission

Tech-Archive recommends: Fix windows errors by optimizing your registry

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).


--
Joan Wild
Microsoft Access MVP

neeraj wrote:
> 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?
>
>
> "Joan Wild" wrote:
>
>>
>> neeraj wrote:
>>> 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
>>
>> 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.
>>
>> --
>> Joan Wild
>> Microsoft Access MVP


.

Quantcast