access db ability

[Pam Coleman]

I would like to have the ability for (lets use the number 3 for example) three
employees to enter data into their own spreadsheet or database. I would like
for person 1 to be able to see everything that they have entered, but not
what person 2 and 3 have entered. The same applies to other users. Then, I
would like to have all 3 of their data to be consolidated as it is entered
into one database that only I will have access to. Is this possible? Thanks,

Also, if this has appeared before, I am sorry, my computer kept locking up
and it looked like it didn't go through.

 

[Ken Snell [MVP]]

This could be done in ACCESS by designing the table to have a field for
storing the ID of the person who entered the data, and then using that field
to filter the data that are displayed to a user based on his/her ID.

 

[Pam Coleman]

I don't understand how this works.

This could be done in ACCESS by designing the table to have a field for
storing the ID of the person who entered the data, and then using that field
to filter the data that are displayed to a user based on his/her ID.

 

[Ken Snell [MVP]]

Which part is not clear?

You would have a field in the table that will contain the data entered by
each person. When a person enters new data, that field is filled in with an
identifier for that person.

To view data entered by that person, you would use a query that filters on
that field's value, returning only the records that have a value that is the
person's ID who is to view the data. So a form that is used to enter data or
to view data would be based on a query that filters based on the ID of the
person who's signed in... and for the "manager" who can see everyone's data,
the query would return all records.

You don't state how you're "separating" the people who enter the data; do
they use their own front end? Do they select their name from a signin
screen? Are you using ACCESS security?

--

Ken Snell
<MS ACCESS MVP>