Permissions for reading database

[Guest]

Hi!

I have Access database shared in a folder (Win XP) for a bunch of users over
a local network. Everyone should only read data (through a form) and use
folder as is, while only local user can change everything, delete and modify
files in a shared folder.

The problem is that I don't know how to implement that. If a I set the
folder sharing permission to only "read" for "Everyone" then they dont have
the abilitiy to use forms for reading (blank form appears, database in read
only mode). If I set the folder sharing permissions to "read" and "modify"
then it's OK, but then everyone can delete files in the folder, including my
database. Security permissions for folder and database seems to be Ok if they
are set to "read&execute" and "list folder contents" for "everyone". I tried
other combinations also, but unsuccesfully.

How to fix this?

Help. Thanks!

 

[guido via AccessMonster.com]

Look up "User level security" in the Access help menu. There are many options
that will allow you to set up security on each element in your database.

 

[Scott McDaniel]

Hi!

I have Access database shared in a folder (Win XP) for a bunch of users over
a local network. Everyone should only read data (through a form) and use
folder as is, while only local user can change everything, delete and modify
files in a shared folder.

All users must have read/write/create/delete permissions on the folder hosting your Access database. This is set through
Windows Security (i.e. right click on the folder and select Properties, then Security). You can remove the delete
permission, but you'll run into locking issue eventually (since all users must be able to create and delete the locking
file that Access creates).

The problem is that I don't know how to implement that. If a I set the
folder sharing permission to only "read" for "Everyone" then they dont have
the abilitiy to use forms for reading (blank form appears, database in read
only mode). If I set the folder sharing permissions to "read" and "modify"
then it's OK, but then everyone can delete files in the folder, including my
database. Security permissions for folder and database seems to be Ok if they
are set to "read&execute" and "list folder contents" for "everyone". I tried
other combinations also, but unsuccesfully.

Since users must have delete permissions on the folder, you're sort of stuck. You can do some other things - for
example, you can setup your system so that your backend is in a shared drive, and set that drive to be hidden ... makes
it a bit harder for users to find, but not impossible. Frequent backups are essential, of course.

How to fix this?

Help. Thanks!

Scott McDaniel
scott@takemeout_infotrakker.com
www.infotrakker.com

 

[Guest]

Thank you, Scott

your reply has confirmed what I suspected by myself, too. Seems that
frequent backups and hiding folders and files is really the only protection
form deleting files in this configuration.
Still it makes me very dissapointed by Microsoft if that's the problem they
left to us without easy solution.

Greetings from Croatia!

 

[Joan Wild]

You can remove the delete permission on the mdb file itself. You just have
to remember to reset it after you compact.