Set up User Restrictions

[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

 

[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