How NTFS Permitions affect a MS ACCESS database?

[KiaKia]

Hi everyone,

I have a MSACCESS DB already in use by different users. to protect my BackEnd DB file (tables only)from deletion and Over writing by users I want to apply some NTFS protection on the folder which is containing my file.
I wonder to know how it will affect user's access to my DB?
For example, a user who has the right to delete or modify a record, will be able to do it after NTFS readonly protection is applied to my DB, or not?

 

[PHV]

Not

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[JoeAtWork]

Your users will need to be able to read and modify the file, and even create and delete files (so they can create the LDB file if they are first in, or delete it if they are last out).

 

[KiaKia]

JeoAtWork,
Thnaks,is there any other way to protect the DB from deletion?

 

[RobSindle]

Don't know if there is a permission that allows R/W but not delete, but if so, that would be something to try.

I'd recommend a book by Garry Robinson.
Title is "Real World Microsoft Access Database Protection and Security"

Rob