I have a split database that I will be sharing with a group of people. I need to save the backend of the database on a server everyone has access to. How would I go about securing the backend to prevent an another user from opening it up or possibly deleting it by mistake?
Would I put the backend in a folder and lock the folder? Would this prevent them from being able to access the data from the front end? Honestly not sure which direction to go with this. Publishing the database as a web app is not an option, so is there a secure way of locking down the back end or do I just need to do daily backups in case the worst happens?
If this is in the wrong thread my apologies, admins feel free to move to correct spot.
Thanks,
Niko