User Permissions - Beware Newbie!!

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
 
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...
 
Back
Top