Can i use Access for this?

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

Guest

Hi everyone,

i'm incredibly green when it comes to databases, and i'd like to solicit
your assistance on something. I'd like to create a DB which will allow
everyone on my network to add data, but not be able to modify anyone else's.
It would be a list of numbers followed, and the people on the LAN would be
entering data under different numbers each day, but basically once a number
is claimed for that day, no one else should be able to modify it. What i'm
wondering is, before i learn Access, does it have the kind of file permission
capabilities to enable a person to add data, but not modify anyone elses, but
the entire database is visible to all?

I hope this is clear. If you have any questions, please let me know. I'd
appreciate any help i could get. Thanks.

Jason.
 
-----Original Message-----
Hi everyone,

i'm incredibly green when it comes to databases, and i'd like to solicit
your assistance on something. I'd like to create a DB which will allow
everyone on my network to add data, but not be able to modify anyone else's.
It would be a list of numbers followed, and the people on the LAN would be
entering data under different numbers each day, but basically once a number
is claimed for that day, no one else should be able to modify it. What i'm
wondering is, before i learn Access, does it have the kind of file permission
capabilities to enable a person to add data, but not modify anyone elses, but
the entire database is visible to all?

I hope this is clear. If you have any questions, please let me know. I'd
appreciate any help i could get. Thanks.

Jason.
.
Click to expand...
Ask your question in the Access Newsgroup.
 
Hi Jason,

With Access, you can have read access, just to see, and write access, so you
can add or delete information. If you are authorized to write, you are
authorized to deleted, it goes together.

I hope this will help you.
 
Yes you can do this with Access, or indeed with any recent database
application; but what you describe are data locking requirements not file
access permissions. However, Access has serious limitations on a network if
you have more than a very few users. They are not insuperable obstacles, but
they are an issue. MSDE might be a better choice (and it's free).
 
Back
Top