NTFS File/Directory Permissions for backend db

[wtmckown]

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?

 

[willir]

wtmckown

Tough one.

Access updates internal system tables whenever a user runs an Access database. Try openning a database on a CD.

The only 3051 error I have seen referenced is ...
thread700-630540 a network admin guy, I found I had to give read/write/modify and create for them to be able to use the table in a noremal fashion. In Novell, they even need file scan; otherwise they can not open the database.

Due to these limitations, either on my ignorance or MS, I implemented security on important databases and I ensure the databases are backed up every day.

Another solution would be to use ODBC, but I find ODBC works better when linking Access to another type of database such as Oracle.

Let me know if you find a better way.

Richard