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

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.

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.