NTFS permissions and MS Access

[TKE402]

Hi,

I have several MS Access DB's that are in a folder that is Read/Execute for
Authenticated users. No one can open the DBs. If I change the permissions to
Read/Write/Execute than it works because the DB lock file needs to be written
to the folder that the DB is located. Is there anyway around this? I do not
want the users to have read,write, execute to that folder. All they need is
read and execute.

Thanks,

TKE402

 

[Arvin Meyer [MVP]]

Hi,

I have several MS Access DB's that are in a folder that is Read/Execute
for
Authenticated users. No one can open the DBs. If I change the permissions
to
Read/Write/Execute than it works because the DB lock file needs to be
written
to the folder that the DB is located. Is there anyway around this? I do
not
want the users to have read,write, execute to that folder. All they need
is
read and execute.

No, and you also need Delete permissions or they won't be able to delete the
LDB file, and only one person at a time will be able to use the database.
You should allow only those permitted to use the database the NTFS
permissions on the data backend, and if you use Access 2003 or earlier, you
can use the built-in User Level Security. For Access 2007, (and earlier
versions as well) you can build security by capturing the Windows login
username and creating your own security:

http://www.mvps.org/access/api/api0008.htm

 

[david]

You can open a database off of a CD or DVD, so you know
that users do not need write permissions. (They do get an
ugly warning though).

Perhaps your problem is that you also have R/W users, and
a R/W user has the file open? If so, your R/O users need
write permission on the LDB (you should remove the delete
permission so that the Write permission is retained, because
otherwise it will be automatically deleted by a R/W user).

Or maybe they need Browse Permission as well (I've never
tried without that).

(david)