Setting network permissions for database

[Bob Sanderson]

I want to put an Access database back end on a network server so that it
can be shared by several users. I plan to use the built-in Access security
to set permissions for the database but am concerned that someone could
delete the back end from the server. What I need to know is what sharing
permissions and security settings I need to apply to the back end and to
the folder it resides in.

Also, can I use the server settings to determine who can make changes to
the database based on the user's login name?

The server is Windows 2000 formated in NTFS.

Any help will be greatly appreciated.

[Rick Brandt]

Bob Sanderson wrote:

I want to put an Access database back end on a network server so that
it can be shared by several users. I plan to use the built-in Access
security to set permissions for the database but am concerned that
someone could delete the back end from the server. What I need to
know is what sharing permissions and security settings I need to
apply to the back end and to the folder it resides in.

Also, can I use the server settings to determine who can make changes
to the database based on the user's login name?

The server is Windows 2000 formated in NTFS.

Any help will be greatly appreciated.

ALL users need file create, file delete, file read, and file modify to use
an Access MDB. This is true even for read-only access unless you want all
users to be read only. So yes, an authorized user can delete your mdb.

Split the app, give each user a front end that links to the shared back end,
and put the back end in a share that the users have full permissions to but
which is hidden. This will deter casual browsers. Then set up a good
backup routine.

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