Hi, I'm going to place the back end Access data file in a shared folder for
common use. Which mininum permissions should I grant users for reading,
editing, deleteing and creating records in that file but without allow
somebody to delete that file from the shared folder.

It would be also welcome if nobody could copy that file.


Thanks in advance,
AK

They users need modify permissions on the folder, so that they can create
the associated ldb file.  Without the create permission the backend will get
opened exclusively.  They do not need delete permission on the folder.

Given these permissions you can't stop them from copying the file.

Consider hiding the share where the backend is located \\server\share$
rather than \\server\share


Show quoteHide quote

How secure is Access 2007
Access 2007 Security
system.mdw
user and group permissions on basis of data
Copy Forms and Tables from Secure DB to other Secure DB
EuroPKI07 Call for Papers
How to hide Database Window for users
workgroup files and 2007
get error message when running a query
Open File Security Warning