How to handle multiple user levels

[nkuebelbeck]

So, I've got this database that needs some users to be read only and some users to have full control. I applied the appropriate ntfs permissions but there is a problem. If a read only users open the database, and then a full control users opens the database its stuck in read-only.



What is the best approach around this?

The database is a 2007 accdb.

Thanks in advance

[alansidman]

Here is an approach that I use.

http://www.mrexcel.com/forum/showthread.php?t=248191

Alan

[nkuebelbeck]

You solution would work, but would require giving full ntfs permission to all users. This might work, but it is risky. Someone could delete the database not knowing any better.

I guess i'd prefer to not use the database to control access. It's messy and easy to get around.