Results 1 to 4 of 4
  1. #1
    data808 is offline Noob
    Windows 8 Access 2007
    Join Date
    Aug 2012
    Posts
    727

    Network Drive Permissions

    Hello,



    I have a frontend/backend database that supports 20-25 users simultaneously. My concern at the moment is that we have the backend file on a network drive, G: Drive to be specific and everyone in the company can view this drive with full control on modifying, reading, and deleting files etc... when we set up these permissions for the network drive years ago I have this memory that we had to give them full control in order for them to be able to enter records into the database. Not sure if that is accurate or not. I did limit certain permissions of my own into the database itself on certain forms for certain users so everything is working perfectly as it should. What I worry about now is if someone deletes the whole backend file, all the records will be lost.

    Is there any permissions that can prevent this while also allowing the users to be able to add/modify records into the database? I have a feeling modify, read, and write may be enough to secure the backend file from getting deleted but not sure if that will stop users from adding records to the backend file. We use Windows 7. Here is a list of the permissions that are available:

    Full control
    Modify
    Read & Execute
    List folder contents
    Read
    Write
    Special permissions

    If a solution is not available for this scenario, I would also like to ask if there is such a thing as a ghost network drive? A network drive that is there in the background but cannot be seen by the user. If so, that is where I would plan to keep the backend file safe from accidental deletion. Let me know what you think.

    Thanks for any help you can provide.

  2. #2
    pbaldy's Avatar
    pbaldy is online now Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,518
    If you share the folder with a $, it's a hidden share ("ShareName$").
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

  3. #3
    data808 is offline Noob
    Windows 8 Access 2007
    Join Date
    Aug 2012
    Posts
    727
    thanks for the reply.

    would this be applied to the name of the folder on the network drive?

  4. #4
    pbaldy's Avatar
    pbaldy is online now Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,518
    Not the name itself, the name given during the sharing process.
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Opening Files from a network drive
    By hinchi1 in forum Access
    Replies: 5
    Last Post: 06-10-2018, 04:04 AM
  2. Problem Saving PDF to Network Drive
    By David Ford in forum Reports
    Replies: 1
    Last Post: 02-05-2016, 01:16 PM
  3. Accessing MDB on network drive
    By thecsmith70 in forum Access
    Replies: 6
    Last Post: 02-19-2015, 03:21 PM
  4. Mapped network drive used, away from home
    By Cleave_1b in forum Misc
    Replies: 2
    Last Post: 12-26-2014, 04:07 PM
  5. Max users on a network drive
    By data808 in forum Access
    Replies: 2
    Last Post: 10-23-2014, 02:12 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums