nt file permissions for backend database

[wtmckown]

I put this out here earlier and got a kind of 'wish I knew' reply and would like to repost in an effort to get another response.

I have searched for and reviewed the threads and faqs on access security but have not seen specifically what I am looking for. I have a split access application and I want to secure the backend database so that it can't be browsed to with windows explorer. I don't want people to be able to open it, delete it or even take a copy of it. I have tried a variety of methods in vain. It seems that I need to leave a path open to the database folder in order for table links to refresh. I have tried a share from the database folder but the clients can't refresh their table links unless they get read permission (minimum) from the root to the database folder. Here's what I currently have:

root
Level1
Level2 - backend.mdb

Level1 folder should allow only administrators
Level2 folder is shared with everyone group at full access
Level2 folder is set up fof administrator full access and for my user group to have read/write/modify

When attempting to relink my users are getting 3051 - Can't open backend.mdb

Any ideas on how to set this up?

 

[Kanga35]

right accesses start from the root... you have to access the root to go to level 1 then 2.

 

[wtmckown]

Should it not be possible to access Level2 via the share of the Level2 folder?