If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Access 2003 - Timesheet Form to be accessed by multiple users
I have an Access Database which has been created to keep track of hourly
employees (name, date worked, the reason worked, start time, end time, and total hours for the day). Right now, the information is being put in Word, and someone has to re-type the information into Access. Is there a way I can restrict the form so that Person1 can only "see" his/her information and Person 2 can only see his/her information? I would like to be able to have each person who fills in a timesheet type the information directly into Access, but I would like to make it so that they cannot see any other person's information, or change existing information. Is this possible? Thank you. Brenda |
#2
|
|||
|
|||
Access 2003 - Timesheet Form to be accessed by multiple users
On Thu, 21 Dec 2006 13:49:01 -0800, B. Levien
wrote: I have an Access Database which has been created to keep track of hourly employees (name, date worked, the reason worked, start time, end time, and total hours for the day). Right now, the information is being put in Word, and someone has to re-type the information into Access. Is there a way I can restrict the form so that Person1 can only "see" his/her information and Person 2 can only see his/her information? Yes, though it's not simple. You need to set up Access user level security to (1) require users to log in to the database with a user name and password and (2) deny ordinary users any access to the table. You can then bind the form to a query that (a) has "owner permissions" to access the table and (b) filters the table to return only that user's records. Access user level security is quite complicated and it's easy to set it up in a way that doesn't actually provide any security - or even to lock yourself permanently out of the database. Before you try to use it, download and study - carefully - the security FAQ at http://support.microsoft.com/default...2F SECFAQ.asp and then make sure you have a backup copy of the database before you start. The FAQ says it applies to Access 2.0 to 2000, but the system in Access 2002 and 2003 is just the same. The system is good enough for most use but it's not unbreakable: if you need a really secure system you should use a heavyweight server database engine such as SQL Server - but you can still use Access for the forms and reports and the rest of the front end. I would like to be able to have each person who fills in a timesheet type the information directly into Access, but I would like to make it so that they cannot see any other person's information, or change existing information. Set up user-level security as above to prevent users seeing other users' records. Then set the Form's AllowAdditions property to True (to let the user enter new records) and AllowEdits to False (to prevent them changing existing ones). -- John Nurick [Microsoft Access MVP] Please respond in the newgroup and not by email. |
#3
|
|||
|
|||
Access 2003 - Timesheet Form to be accessed by multiple users
Thank you very much!
I will try the below! Brenda "John Nurick" wrote: On Thu, 21 Dec 2006 13:49:01 -0800, B. Levien wrote: I have an Access Database which has been created to keep track of hourly employees (name, date worked, the reason worked, start time, end time, and total hours for the day). Right now, the information is being put in Word, and someone has to re-type the information into Access. Is there a way I can restrict the form so that Person1 can only "see" his/her information and Person 2 can only see his/her information? Yes, though it's not simple. You need to set up Access user level security to (1) require users to log in to the database with a user name and password and (2) deny ordinary users any access to the table. You can then bind the form to a query that (a) has "owner permissions" to access the table and (b) filters the table to return only that user's records. Access user level security is quite complicated and it's easy to set it up in a way that doesn't actually provide any security - or even to lock yourself permanently out of the database. Before you try to use it, download and study - carefully - the security FAQ at http://support.microsoft.com/default...2F SECFAQ.asp and then make sure you have a backup copy of the database before you start. The FAQ says it applies to Access 2.0 to 2000, but the system in Access 2002 and 2003 is just the same. The system is good enough for most use but it's not unbreakable: if you need a really secure system you should use a heavyweight server database engine such as SQL Server - but you can still use Access for the forms and reports and the rest of the front end. I would like to be able to have each person who fills in a timesheet type the information directly into Access, but I would like to make it so that they cannot see any other person's information, or change existing information. Set up user-level security as above to prevent users seeing other users' records. Then set the Form's AllowAdditions property to True (to let the user enter new records) and AllowEdits to False (to prevent them changing existing ones). -- John Nurick [Microsoft Access MVP] Please respond in the newgroup and not by email. |
Thread Tools | |
Display Modes | |
|
|