User Level Security

Resolved · Low Priority · Version 2003

Thu 4 Jun 2009, 10:39 Delegate Azlina said...

Azlina has attended:
Dreamweaver 8 Introduction course

User Level Security

I have a database on a shared drive in work. There are 7 people accessing this database with myself as the administrator. I've tried using the User Level Security Wizard and maybe it's just because I'm a bit slow but I cannot get it to work.

I would like to restrict the 6 other staff members' use of the database to just being able to add and view data but definitely not be able to delete anything as it took me many painstaking hours to collaborate all the information. I thought this could be done through their login details to the database but I can't get it to work and I have no idea what I'm doing wrong.

Please help!

Mon 8 Jun 2009, 08:47 Trainer Rajeev said...

RE: User Level Security

Dear Azlina

Thank you for your query!

Please refer to the below link which provides the theory as well as practical side to creating user levels and setting permissions.

http://office.microsoft.com/en-us/access/HA101662271033.aspx

It focuses on Access 2007 but the 203 is very similar as long as you know how to access the User Level Security wizard!!

I hope this has answered your query.

If this has answered your query then I would request you to please mark the question as resolved!! If not and you have a specific question related to this then please post it as a new question and we should be able to provide you the solution for it!!

Kindest Regards

Rajeev Rawat
MOS Master Instructor 2000 and 2003
MCAS Master Instructor 2007
MCT

Training courses

	98.7 % recommend us
	More live stats...

Training information:

Access tip:

Zoom feature for queries

If youare working on on query design and creating a calculated field, it can be hard to view the whole statement. You can hold the shift key down and press F2, to show the zoomed up version of the query field

View all Access hints and tips