|
security
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
An easy solution??? Folder permissions...I would prefer not to fool around with MS Access security if I don't have to.
I only need two simple types of users - administrators who have access to everything, and read-only users who cannot enter information or anything...they can only look at the information in the database. Does anyone know if I can cheat in this instance by assigning read only and write/modify permissions to the FOLDER in which my DB sits...anyone know if this works with Access as it would with Word? Thanks for any assistance! Tanya Hi Tanya,
No, that will not work. Access requires that all users have full permissions to the folder where the database resides. However, you can set the permissions on the database itself to read only for some users and write/modify for others. Show quoteHide quote "Tanya Lee" <Tanya***@discussions.microsoft.com> wrote in message news:48873781-F32D-4321-A446-43CE4F5BD076@microsoft.com... >I would prefer not to fool around with MS Access security if I don't have >to. > I only need two simple types of users - administrators who have access to > everything, and read-only users who cannot enter information or > anything...they can only look at the information in the database. > > Does anyone know if I can cheat in this instance by assigning read only > and > write/modify permissions to the FOLDER in which my DB sits...anyone know > if > this works with Access as it would with Word? > > Thanks for any assistance! > Tanya Lynn,
I didn't know that about the folder. Thank you for the information! Tanya Show quoteHide quote "Lynn Trapp" wrote: > Hi Tanya, > No, that will not work. Access requires that all users have full permissions > to the folder where the database resides. However, you can set the > permissions on the database itself to read only for some users and > write/modify for others. > > -- > > Lynn Trapp > Microsoft MVP (Access) > www.ltcomputerdesigns.com > > > "Tanya Lee" <Tanya***@discussions.microsoft.com> wrote in message > news:48873781-F32D-4321-A446-43CE4F5BD076@microsoft.com... > >I would prefer not to fool around with MS Access security if I don't have > >to. > > I only need two simple types of users - administrators who have access to > > everything, and read-only users who cannot enter information or > > anything...they can only look at the information in the database. > > > > Does anyone know if I can cheat in this instance by assigning read only > > and > > write/modify permissions to the FOLDER in which my DB sits...anyone know > > if > > this works with Access as it would with Word? > > > > Thanks for any assistance! > > Tanya > > > 
Other interesting topics
User level security-- do not have necessary permissions
mapped network drive and security error restrict combo box selection depending on user Tab Change Passwords how to change a name in "msysaccounts"? Programically redirecting to different mdw files Can't open Secured Access 2003 Database in Access 2007 Open an Access Database from Another Secure back end database user without admin privilleges was able to join his computer to do |
|||||||||||||||||||||||
