Set up User Restrictions

6 Nov 2008 4:05 PM

BonRobi

Is there a way to restrict users to specific information?

I have set up a database at my workplace. The DB has been split for
multiple users with different functions. Some enter information in forms and
run reports, other can only run reports.

I have set up queries and reports for individuals to view data specific to
their area. Is there a way I can restrict people from accessing records that
do not pertain to them?

I made switchboards so that people could only view criteria specific
reports. However, someone who knows MS Access could access the tables which
stores everyone's information. We would like to prevent this. Is there a
way?

Also, we have tried to restrict the folder where the back end database is
housed but this will not allow those people to access the data (enter forms
or run reports).

Thanks

11 Nov 2008 9:30 PM

Ripper

Not sure what you mean when you say restrict the folder where the back end
resides. How are you restricting it?

Start here: http://support.microsoft.com/kb/207793
with attention to sections 1,2 and especially 10, and be prepared to work
hard at this. It's doable, but not a breeze.

Rip

Show quoteHide quote

"BonRobi" <BonR***@discussions.microsoft.com> wrote in message
news:A5A7CFEA-4D96-4A6B-9BBF-B7E058F034D4@microsoft.com...
> Is there a way to restrict users to specific information?
>
> I have set up a database at my workplace. The DB has been split for
> multiple users with different functions. Some enter information in forms
> and
> run reports, other can only run reports.
>
> I have set up queries and reports for individuals to view data specific to
> their area. Is there a way I can restrict people from accessing records
> that
> do not pertain to them?
>
> I made switchboards so that people could only view criteria specific
> reports. However, someone who knows MS Access could access the tables
> which
> stores everyone's information. We would like to prevent this. Is there a
> way?
>
> Also, we have tried to restrict the folder where the back end database is
> housed but this will not allow those people to access the data (enter
> forms
> or run reports).
>
> Thanks