Results 1 to 6 of 6

Access Front End locked but never asks for Password

  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 offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    7,707
    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 Very idle programmer
    Windows 10 Access 2010 32bit
    Join Date
    Jan 2014
    Location
    Somerset, UK
    Posts
    3,737
    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 (Mendip Data Systems) : Website, email
    If this has helped, please click the star button and leave a comment

  4. #4
    Ajax is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    7,553
    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 offline Virtually Inert Person
    Windows 10 Access 2016
    Join Date
    Jun 2014
    Location
    Ontario, Canada
    Posts
    6,289
    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.
    - "doesn't work" is no help. Post err msgs and where.
    - Use code tags for code/sql. Implement changes in copies of your database.

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
  •  
Tech Forums: Microsoft Office Forums