I inherited a large Access Database where the users have their own copies of the Front End database.
I can see that the front-End hides the tables and the vba code but it does not ask for pwd t open it.
What kind of security type is this?
I inherited a large Access Database where the users have their own copies of the Front End database.
I can see that the front-End hides the tables and the vba code but it does not ask for pwd t open it.
What kind of security type is this?
you can hide the tables via:
DoCmd.SelectObject acTable, , True
DoCmd.RunCommand acCmdWindowHide
unhide:
DoCmd.SelectObject acTable, , True
If the code is hidden its probably an ACCDE file.
As Ranman explained its easy to hide the tables but equally easy to show them again.
Adding a password to an ACCDB or ACCDE database encrypts the file as extra security.
Alternatively you can have users login with a user name and password combination.
If you want additional security, there is much more you can do. See http://www.mendipdatasystems.co.uk/i...ity/4594461803
another possibility is that the navigation window has been hidden - it can easily be shown again by hitting F11
or perhaps the developer has just hidden the tables - to show them, go to File>Options>Current Database>Navigation Options and tick the show hidden objects option. Also try Show System Objects in the same location.
I'm surprised that when you inherited the app you did not also inherit documentation if you are expected to maintain it.
Thank you, I will poke around. This is a small company and the developer left angry without documentation
another possibility is that the navigation window has been hidden - it can easily be shown again by hitting F11
or perhaps the developer has just hidden the tables - to show them, go to File>Options>Current Database>Navigation Options and tick the show hidden objects option. Also try Show System Objects in the same location.
I'm surprised that when you inherited the app you did not also inherit documentation if you are expected to maintain it.
I'd strongly recommend that you poke around in a copy of the database and backup your "poked" efforts as you go - probably with the date as part of the file name.Thank you, I will poke around.
The more we hear silence, the more we begin to think about our value in this universe.
Paraphrase of Professor Brian Cox.