rsclark
asked on
Access database NTFS permissions to add records but not modify
Hi
Don't know if this is possible, but here is what I am after.
One of my offices runs a number of Access databases. All staff have full permissions on them. These work OK.
The managers want to introduce a new application that they want ordinary staff to have permissions to add records to, but not to modify existing records. Managers should have permission to change reocrds. Is this possible with NTFS permissions with two different security groups?
Reluctant to start using WorkGroup Security as I have found it a pain in the neck!
Regards
Robert
Don't know if this is possible, but here is what I am after.
One of my offices runs a number of Access databases. All staff have full permissions on them. These work OK.
The managers want to introduce a new application that they want ordinary staff to have permissions to add records to, but not to modify existing records. Managers should have permission to change reocrds. Is this possible with NTFS permissions with two different security groups?
Reluctant to start using WorkGroup Security as I have found it a pain in the neck!
Regards
Robert
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
I never said it wasn't possible with workgroup administrator... just that I avoid access whenever possible and would recommend using SQL instead (especially with SQL Express free and the SQL Management Studio available to manage it).
ASKER
So if I use Workgroup Administration, can I apply it to just one access database leaving the others untouched?
Yes - I know that's the case - but I haven't done it it... probably a different question... the original question is a flat out no, not possible.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
All very good and helpful - many thanks for all your contributions.
Robert
Robert
However, It is possible to use the security within access to do what you want, I have written a number of access databasea that do just that. Security in access isn't really that bad - once you are used to it.