Can Access help?

J

Jason

Hi there, I'm hoping someone can help me.

I've never used Access before and was wondering if it could accomodate my
needs. I'd like a database on my LAN where employees could each enter in
data but could not modify it or anyone else's data once they enter it. I
would like the DB to available for all to see, but just that not everyone
could modify the data in them...they could only add. For example,

Number Employee Data

1 Steve 203405
2 Donna 203406
3 Tom 203407
4
5


Now, for 4 and 5, any employee can enter the DB, enter the data for their
number but cannot modify any of the other data and cannot change theirs once
they enter it.

I hope this makes sense. I'm trying to be as clear as i can.

Anyway, my question is this: Should i begin to learn Access? Will Access
serve these needs for me? I don't mind studying it, but i'd like to know if
it is indeed the program i need to get what i want.

Thanks to any who take the time to respond,

Jason.
 
N

Neal

You can set individual permisions. If you have access check out
Tools_Security. You will find all of the information there.
 
L

Larry Linson

With a carefully implemented application, you can include the userid in the
fields (get it from the CurrentUser function), and allow access only via
queries. You will need to apply Access security.

Larry Linson
Microsoft Access MVP
 
Top