Hi - I posted the message below on the Access Forms forum, but I'm not sure I'll get a reply on my security problem, so I'm posting here as well.....
I have a couple of questions regarding a form in an Access 2000 database. The form is very simple, consisting only of an ID field, a title associated with the ID, three date fields, a comment field, and a search button so that the user can bring up data associated with the ID number.
I used the Security Wizard to establish security on the database for two different groups. The group in question here has rights to change the data on the form but not the design of the form (I think it’s called Full Data rights).
The first thing I need to accomplish is to require that an entry be made in the comment field if the information in any of the three date fields is changed. I know you can use the Validation Rule to have a message box pop up stating that the information is required, but is there any way to keep the date information from updating if the comment field isn’t completed? (Note - the original data can be entered in the data fields without the need of a comment.)
My second question involves security. I have the two security groups set up so that the one group can only update data. However, when they use their password to log into the database, they can view all of the reports, forms, etc. Is there any way that, once they log in, they can only see the one form they need to update, while the other group of users can still have full access to all the objects in the database?
Sorry if these are easy questions, but I’m still trying to learn…..Please respond with any suggestions. Thanks!
I have a couple of questions regarding a form in an Access 2000 database. The form is very simple, consisting only of an ID field, a title associated with the ID, three date fields, a comment field, and a search button so that the user can bring up data associated with the ID number.
I used the Security Wizard to establish security on the database for two different groups. The group in question here has rights to change the data on the form but not the design of the form (I think it’s called Full Data rights).
The first thing I need to accomplish is to require that an entry be made in the comment field if the information in any of the three date fields is changed. I know you can use the Validation Rule to have a message box pop up stating that the information is required, but is there any way to keep the date information from updating if the comment field isn’t completed? (Note - the original data can be entered in the data fields without the need of a comment.)
My second question involves security. I have the two security groups set up so that the one group can only update data. However, when they use their password to log into the database, they can view all of the reports, forms, etc. Is there any way that, once they log in, they can only see the one form they need to update, while the other group of users can still have full access to all the objects in the database?
Sorry if these are easy questions, but I’m still trying to learn…..Please respond with any suggestions. Thanks!
