Different Rights for Different Users

[CSCS]

Hi All,

It's me again!!

I have another question.

I'm designing this system in which each end user should has a password, and each user has different rights, some can just read, some can add, some can update and some can delete.

how can I achieve that?

I also want to know how can I disable the auto save in MS access, as we know access does auto save. I want access to save only when a save button is clicked.

Any help will be very much appreciated.

Many thanks and regards,
CS.

 

[jammyp]

Hi CS,
look into using the Workgroup information File / Microsoft Access Workgroup.
you can create users with passwords and give them access to update tables / delete, etc.

 

[ColinEssex]

Alternatively, you can have a LoginTable of usernames and their access level (Full / Read etc)

When they open a form, have some code that checks their level and amends the forms properties accordingly

I use this to stop Senior Managers mucking about with the data (they are read only) and leave the edits / adding data to the users who know what they're doing

I thought this workgroup business was a bit too complex, to be honest.

Col

 

[ghudson]

I also want to know how can I disable the auto save in MS access, as we know access does auto save. I want access to save only when a save button is clicked.

Access does not have an auto save function. Access will save a record when the focus is moved to another record if the current record is dirty. I conquered the same problem you are trying to solve with my better mouse trap solution.

Workgroup security will not prevent a user from saving a record if they have full rights to the data.

These might be useful to you…

A Better Mouse Trap?

Enable/Disable The Control Box X Button

You want to use the forms Before Update event for data validation. If that is the route you are taking.

 

[wilko]

Alternatively, you can have a LoginTable of usernames and their access level (Full / Read etc)

When they open a form, have some code that checks their level and amends the forms properties accordingly

I use this to stop Senior Managers mucking about with the data (they are read only) and leave the edits / adding data to the users who know what they're doing

I thought this workgroup business was a bit too complex, to be honest.

Col

Hi Colin,

I have created myself a login screen, I am only going to be having two types of user, which include admin (who have ability to do anythign they want) and the other is 'student' - who I only want to have the ability to read the database.

At the moment, depending who logs on, points them to different forms. Ideally I would like it so that when admin login they can have their full privileges, and when students logon only to be able to read the db. Any suggestions here?

Cheers,

Ross

 

[iangirven]

Ross
I did this by adding some code to check a users status ie read only. If the person only had read only access i set a global variable to 1. On opening each form I ran some code to check the variable. If it was 1 the form opened in read only mode and if not 1 then data entry and editing was permissible.

hope this helps

regards
ian