Results 1 to 6 of 6
  1. #1
    mhni is offline Novice
    Windows 10 Access 2013 32bit
    Join Date
    Aug 2019
    Posts
    2

    Access Front End locked but never asks for Password

    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?

  2. #2
    ranman256's Avatar
    ranman256 is online now VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    you can hide the tables via:
    DoCmd.SelectObject acTable, , True
    DoCmd.RunCommand acCmdWindowHide

    unhide:
    DoCmd.SelectObject acTable, , True

  3. #3
    isladogs's Avatar
    isladogs is offline MVP / VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jan 2014
    Location
    Somerset, UK
    Posts
    5,954
    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
    Colin, Access MVP, Website, email
    The more I learn, the more I know I don't know. When I don't know, I keep quiet!
    If I don't know that I don't know, I don't know whether to answer

  4. #4
    CJ_London is online now VIP
    Windows 10 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    11,397
    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.

  5. #5
    mhni is offline Novice
    Windows 10 Access 2013 32bit
    Join Date
    Aug 2019
    Posts
    2
    Thank you, I will poke around. This is a small company and the developer left angry without documentation

    Quote Originally Posted by Ajax View Post
    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.

  6. #6
    Micron is online now Virtually Inert Person
    Windows 10 Access 2016
    Join Date
    Jun 2014
    Location
    Ontario, Canada
    Posts
    12,737
    Thank you, I will poke around.
    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.
    The more we hear silence, the more we begin to think about our value in this universe.
    Paraphrase of Professor Brian Cox.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 1
    Last Post: 11-02-2016, 08:36 AM
  2. Replies: 4
    Last Post: 07-11-2015, 12:54 PM
  3. Replies: 7
    Last Post: 03-13-2013, 07:34 PM
  4. Replies: 1
    Last Post: 07-24-2012, 06:10 PM
  5. Replies: 2
    Last Post: 02-15-2011, 05:13 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums