Sherman6789
Programmer
Hello everyone,
I am very reluctant to setting up the built-in Access security because I keep hearing horror stories about problems and potential problems that can result in corrupted data or not being able regain entry to the database.
I am creating a multiuser database in our office and need a method of controlling what various groups of people can see or do in the database. These people are NOT the type to purposely try to harm the database or get into areas that they should not. However, there are about 5-groups of employees and they should see or have the capability to modify only certain parts of the file. Low security is needed.
How can I make a matrix using simple passwords to control this? Even though there are 5-groups, each person still needs to have his or her own password. Not one password for the group. I think that making a protected log-in form which will determine what forms each individual can see would be great. Some of the information needed for the forms and reports would be filled in automatically because the program would know who is signed on, who updated a file and when, automatically record the time they worked on a project, etc.
Any help would be appreciated.
I am very reluctant to setting up the built-in Access security because I keep hearing horror stories about problems and potential problems that can result in corrupted data or not being able regain entry to the database.
I am creating a multiuser database in our office and need a method of controlling what various groups of people can see or do in the database. These people are NOT the type to purposely try to harm the database or get into areas that they should not. However, there are about 5-groups of employees and they should see or have the capability to modify only certain parts of the file. Low security is needed.
How can I make a matrix using simple passwords to control this? Even though there are 5-groups, each person still needs to have his or her own password. Not one password for the group. I think that making a protected log-in form which will determine what forms each individual can see would be great. Some of the information needed for the forms and reports would be filled in automatically because the program would know who is signed on, who updated a file and when, automatically record the time they worked on a project, etc.
Any help would be appreciated.
