Access security

[mar10]

Ok I'm still trying to figure out security for a small database I'm
doing for a firm with 4-5 employees. I'm trying to read as much as
possible before I give it a try because it sounds like some problems
can be caused if it's not done properly.

My current concern is if I create the database on my own PC and do the
security on the database locally and then provide the MDB file along
with the security file to the users will they be able to just copy both
files to their lan and then open it with the security activated WITHOUT
doing any security manipulation from their local machines?

I'm also wondering if it may not be easier to just get their lan
administrator to assign read only access to the directory where the
file will be held for some individuals, and read/write to others.
Have stumbled on a few comments about this as well. Any thoughts?

Thanks for the assistance.

[Rick Brandt]

mar10 wrote:

Ok I'm still trying to figure out security for a small database I'm
doing for a firm with 4-5 employees. I'm trying to read as much as
possible before I give it a try because it sounds like some problems
can be caused if it's not done properly.

My current concern is if I create the database on my own PC and do the
security on the database locally and then provide the MDB file along
with the security file to the users will they be able to just copy
both files to their lan and then open it with the security activated
WITHOUT doing any security manipulation from their local machines?
They will need to create a shortcut that launches Access with the MDW file that
you provide. Otherwise they would have to use the workgroup administrator
utility to make your supplied MDW file their default workgroup file (not
recommended).
I'm also wondering if it may not be easier to just get their lan
administrator to assign read only access to the directory where the
file will be held for some individuals, and read/write to others.
Have stumbled on a few comments about this as well. Any thoughts?

Won't work. Network security can let some people do everything and others do
nothing. It cannot be used to provide read-only for some and full access for
others. All users need full access not only to the MDB file, but to the folder
containing it.

--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com