Users on a Multiuser DB

C

Cowji

Masters of Mircosoft Access,

Before I explain what I am struck on, I will explain the DB layout. My DB
has been split into Backend and Front-end. And each User Group has there own
DB front-end, where only the tables needed have been linked.

I am about to add User-Level Security using the wizard, but after testing
them I am not sure if any does the following:
Allow access to FORMS and REPORTS ONLY. And able to Add New and Amend
Click to expand...
old records
NO ONE apart from Admin, is able to add tables or edit or delete table structures.

NO ONE apart from Sales is able to add/edit/delete queries.
Click to expand...
NO ONE apart from Admin and Sales is allow to view the queries and Table
Click to expand...
structures, only the forms/report which are using the tables.
Show WHICH user is currently using the system and to log this information.
Click to expand...

Thanks in Advance. I would be glad from any help you can provide.

Cowji
 
Top