Does anyone know of a reliable way to prevent users to access tables?
Making an accde file, creating backend and linking to it through some "hidden" location, hiding table by setting attributes and etc are all good ways to partially prevent users to access data. But knowledgeable user will find a way to get to data. What I'm looking for is to truly lock access to the tables.
What I have done before was to hide all the database objects, panels, disable shortcut keys and disabled shift key function on start-up via vba. Then I had a button on one of the forms that would prompt for a hard coded password, and then unlock database objects if password matched (for admin purposes of course). That's the only way I found to prevent users to get to the tables. Does anyone have any other suggestions how to prevent users to view tables.