Folder Permissions for backend db in Win2k

[Anubis3000]

Hi,

I have a question in regards to setting folder permissions for a backend database. To give some background, I have 2 parts of my db, the front end and backend. The front end is public, anyone can read/write/execute. The back end is in a folder that restricts access; no one except the administrator should be able to open the folder. This is done so that no one can just go in and delete the backend data.

My problem is that the folder permissions are interfering with the frontend backend links. When the folder is set to execute only, the backend fails to link to the front end.
When the folder is set to execute and read, the front and backend need to be connected each time the front end is opened.

What permissions should I set the folder to? Should I set the security properties of the backend database to a specific setting? Thanks.

 

[PHV]

For proper locking (.LDB file) the users should have FULL right on the folder, the .MDB may be delete protected however.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[Anubis3000]

Just to clarify, are we talking about folder permissions, or file (permissions on the access file) itself?

I have managed to set the backend folder's permissions to allow (checked) "modify", "read & execute", "list folder contents", "read" and "write" and disallow "full control."

Under the "advanced" tab, I have explicity denied delete permission to non-administrative users.

My problem now is, that the .ldb files or locking files will not delete themselves.

Any advice appreciated. Thanks.

 

[PHV]

As I already stated:
full permission on folder
deny delete permission on .mdb file

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886