I've searched online and have found some tutorials to do a login form with a userID and password. The userID and Password is stored in a table. However, they don't say how to lock this table from view to the user. If you hide the table thats ok I guess but if the user knows how to unhide the table containing all this confidential information, what is the point of having a userID or Password. I feel like there has to be a solution to this. The table can't just be hidden. Its needs to be locked and have a password to open it.
I also should mention, I already know how to password encrypt the entire database which is not suitable for my situation because I will be having a lot of different users using this database. I also know about front end and back end. Password encrypt the back end then link the table to the front end but once you link it to the front end, the front end stores the password and will no longer require a password to view the table. So my question is extremely specific. How do you lock just the table from view? Not just hide it?