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.