Results 1 to 6 of 6

Password Protection With a Table

  1. #1
    surfdragon is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Jul 2016
    Posts
    3

    Password Protection With a Table

    Hi, I have taken over the running of our units databases certain areas of which are password protected. We need to change the passwords on these.
    It looks as though these are set up in a table in the back end, however when I change the passwords in the table then try them out, its just like entering an incorrect password. I cannot then re-set the password to the old setting.


    Any help or any light anyone can shed on this would be very helpful

  2. #2
    RuralGuy's Avatar
    RuralGuy is online now Administrator
    Windows 10 Access 2013 32bit
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,625
    What makes you believe the passwords are "set up in a table in the back end"?
    (RG for short) aka Allan Bunch Previous MS Access MVP - WinXP Pro, Win7 Pro Win10 Pro - acXP, ac07, ac10, ac13
    How to mark the thread as Solved!
    Teaching is not filling a bucket but lighting a fire.
    Borrowed quote..."Docendo discimus"

  3. #3
    surfdragon is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Jul 2016
    Posts
    3
    I have found through various searches how my predecessor did it. I just cannot work out how to change it. I believe there may be "hidden" tables which I cannot locate?

  4. #4
    RuralGuy's Avatar
    RuralGuy is online now Administrator
    Windows 10 Access 2013 32bit
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,625
    You should be able to go to File>Options>Current Database>Navigation>Navigation Options (button) and display all Hidden and System objects.
    (RG for short) aka Allan Bunch Previous MS Access MVP - WinXP Pro, Win7 Pro Win10 Pro - acXP, ac07, ac10, ac13
    How to mark the thread as Solved!
    Teaching is not filling a bucket but lighting a fire.
    Borrowed quote..."Docendo discimus"

  5. #5
    NTC is offline VIP
    Windows 7 64bit Access 2013
    Join Date
    Nov 2009
    Posts
    2,342
    Assuming we are discussing a .accdb file type and not the old .mdb security set up. I so rarely use this feature I am pretty foggy - - there just may not be an explicit "change pw" feature and once you are in using the current PW you just do a create password........ The primary purpose of this is if someone directly connects to the back end file without having the front then they can't open and in this regard it works fine. It doesn't have anything to do with hidden tables - and ruralguy has point out that topic....

  6. #6
    Micron is offline VIP
    Windows 7 32bit Access 2007
    Join Date
    Jun 2014
    Location
    Ontario, Canada
    Posts
    2,934
    and these table fields you seem to have discovered which appear to contain passwords - do the values look like alphanumeric characters that resemble passwords or are they a jumble of odd looking characters? Wondering if they're coded ascii values that you're trying to replicate. On a security scale of 1 to 10, password fields in table of your db is about level 3 (keeping out only the least knowledgeable) if encrypted, less if not. Sometimes I guess that's enough for the user crowd at hand.
    - "doesn't work" is no help.Error #s/text do. State what's happening.
    - Use code tags for code/sql; show where errors occur
    Make all suggested changes in copies of your database or to its objects

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

Similar Threads

  1. Password protection
    By elico in forum Programming
    Replies: 7
    Last Post: 03-27-2016, 03:35 PM
  2. Reports Security Protection
    By mussy in forum Security
    Replies: 3
    Last Post: 06-28-2013, 12:58 PM
  3. Replies: 7
    Last Post: 03-12-2012, 08:18 AM
  4. Password protection
    By peshonzi in forum Forms
    Replies: 1
    Last Post: 07-07-2011, 03:09 AM
  5. help please. i need basic access privacy/protection ideas
    By helpporfavorplz in forum Security
    Replies: 1
    Last Post: 02-20-2010, 04:32 PM

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