User Permissions - Beware Newbie!!

L

Lindsey M

Hi, i'm very new to access so I'm sorry if this question is really simple

Basically I'm creating a Room Booking database and I want the users to be
able to book various meeting rooms and equipment. Now certain users (e.g.
Senior Managers, Section Managers) need to be able to overwrite previous
bookings, whereas other users (Team Managers etc) cannot overwrite previous
bookings.

Can anyone give me guidance on where I would start with this? Any help would
be greatly appreciated!

Cheers
Lindsey
 
E

Ed Robichaud

One solution is to implement Access security that requires assigning users
to levels and controlling forms and menus to those levels. This may be a
challenge for a new developer.

Another solution would be to have two different front-ends (you have split
your database haven't you? If not, see Access Help and use the
Tools-Database splitter menu to do so.) One front end would have data entry
forms to add new records, but view-only forms to see existing records. The
other front-end would have forms that allow add/edit/delete of all records.

-Ed
 
N

Nikki

Lindsey M said:
Hi, i'm very new to access so I'm sorry if this question is really simple

Basically I'm creating a Room Booking database and I want the users to be
able to book various meeting rooms and equipment. Now certain users (e.g.
Senior Managers, Section Managers) need to be able to overwrite previous
bookings, whereas other users (Team Managers etc) cannot overwrite previous
bookings.

Can anyone give me guidance on where I would start with this? Any help would
be greatly appreciated!

Cheers
Lindsey
Click to expand...
 
Top