Access user ability

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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 would also apply to any other
user. Then, I would like to have all 3 of their data to be consolidated as
it is entered into one database that I only will have access to. Can this
be done in Excel or would access be better?
 
Pam said:
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 would also apply to any other user. Then, I would like to have
all 3 of their data to be consolidated as it is entered into one
database that I only will have access to. Can this be done in Excel
or would access be better?
Click to expand...

Sure, there are several approaches.

First I suggest splitting the database so all the data is stored on the
server in a database called the back end. Each user will then have a front
end database on their own machine.

I would link each user to the back end database. Their database can be
set to filter the data so they can only see their own data. You will need
to add a field that identifies what user created it and arrange for it to be
auto filled as they enter data. Don't relay on them filling in the correct
ID.
 
Back
Top