Password to enter data into table from form.

[Guest]

I am creating a fairly simple database that is for a technical work place. We
basically keep a log of events that go on through the day. I am creating a
database in access for that. The problem I have is that each employee should
not be able to make entries under other employee names. Also there is a daily
report of each entry and who made them. So what I am trying to do is on the
form where we make the entry into the daily report table, is to verify user
ids and passwords from another table (with personnel information) , if that
user ids and passwords match then go ahead and update the table with the
information to add to the daily report.

 

[Joseph Meehan]

I am creating a fairly simple database that is for a technical work
place. We basically keep a log of events that go on through the day.
I am creating a database in access for that. The problem I have is
that each employee should not be able to make entries under other
employee names. Also there is a daily report of each entry and who
made them. So what I am trying to do is on the form where we make the
entry into the daily report table, is to verify user ids and
passwords from another table (with personnel information) , if that
user ids and passwords match then go ahead and update the table with
the information to add to the daily report.

I believe you will need to activate user level security.

I suggest you start by reading
http://support.microsoft.com/default.aspx?scid=kb;[LN];207793

Access security is a great feature, but it is, by nature a complex product
with a very steep learning curve. Properly used it offers very safe
versatile protection and control. However a simple mistake can easily lock
you out of your database, which might require the paid services of a
professional to help you get back in.

Practice on some copies to make sure you know what you are doing.

It pay be possible to cook up your own password system as well.