So, I have a database which contains sensitive data, so I only want certain people to have access to it. I also want to restrict it so the database is restricted so the users can't accidentally break things. A user on another forum suggested the following, but didn't go into detail as that's not what the thread was actually about. I've included any comments I have regarding these suggestions below the comment itself.
operating system security, setting user access to folders
-This would be managed by a different department who would charge us, I'd rather not go down that route.
having a table of user names, allowing only those users access to the database (the function : Environ("username") provides the user name, no need for the user to log in to the database or to provide a password
-I like this idea but not sure how to do it, assistance would be good. would it use the username used to log onto the machine?
the production version of the database will be an accde
-I'm not sure what was meant by this
create a customized ribbon with only the features you decide on
-again, this could work but I'm not sure how to do it.
set options, such as don't allow access to the navigation pane, don't allow shortcut menus or bypass keys
-again, could work, but I don't know how to do it.
you MUST split the database - have the tables in a separate database (back-end) and link to them from the front-end (I have not done this myself, but I have seen it around that you would put a password on this file and when you link to the tables you will include that password. Breaks the rules of forgetting but it would be a good idea to put the password in the front-end, maybe in linking code, so that no one has to remember what it is)
-I don't know what this means or how to go about doing it.
any local tables will be hidden
-I do know how to do this
All assistance would be greatly appreciated.
Any queries, just fire away