| re: Setting network permissions for database
Bob Sanderson wrote:[color=blue]
> 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.[/color]
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
| 
