Workgroup Setup, Permissiions and Multi-user questions

  • Thread starter Thread starter John
  • Start date Start date
J

John

Hello,

I am working on a network file. I would like to set up
permissions for the approx. 5 users of the database.
What do I need to do? I know to right click properties
and select security and then I can add and remove users.
Where can I find out the definitions about the following:
full control, modify, read & execute, read, and write?
Basically, I maintain the database, create tables
structures and relations, queries, reports, and forms. I
want to access to everything, but I would like the data-
entry people to be only allowed to enter and/or modify
data thru the forms. My last question is about multiuser
capabilities of Access. I was under the impression that
this was possible due to record-locking when someone is
trying to modify a record which some one else is on at
the same time. Is that true, if so do I have to do
anything special or does the record locking protection
automatic?

I would greatly help with this.

Thanks
 
John said:
Hello,

I am working on a network file. I would like to set up
permissions for the approx. 5 users of the database.
What do I need to do? I know to right click properties
and select security and then I can add and remove users.
Where can I find out the definitions about the following:
full control, modify, read & execute, read, and write?
Basically, I maintain the database, create tables
structures and relations, queries, reports, and forms. I
want to access to everything, but I would like the data-
entry people to be only allowed to enter and/or modify
data thru the forms.
Click to expand...

Access "user level security" is very comprehensive, but also very
complicated to get it right initially. Locate, download & study the
so-called Access Security FAQ (there are links in various peopls' sig
lines). Plan to spend >at least a few weeks< - if not months - studying that
document & experimenting on throw-away databases, before you start to
understand it properly.

My last question is about multiuser
capabilities of Access. I was under the impression that
this was possible due to record-locking when someone is
trying to modify a record which some one else is on at
the same time. Is that true, if so do I have to do
anything special or does the record locking protection
automatic?
Click to expand...

Access (really, Jet) will not let two users update the same record in such a
way that one user's change is invisibly overwritten by the other user. You
can easily see how this works by opening two forms on the same table, &
trying to edit the same record simultaneously from both forms. You can gain
finer-grained control over what happens in these cases, by trapping the
errors that are raised when conflicts occur. Check out "optimistic locking"
and "pessimistic locking" in online help (or where-ever) for related
information.

HTH,
TC
(off for 2 days)
 
Back
Top