Results 1 to 6 of 6
  1. #1
    surfdragon is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Jul 2016
    Posts
    5

    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 offline Administrator
    Windows 10 Access 2013 32bit
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    What makes you believe the passwords are "set up in a table in the back end"?

  3. #3
    surfdragon is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Jul 2016
    Posts
    5
    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 offline Administrator
    Windows 10 Access 2013 32bit
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    You should be able to go to File>Options>Current Database>Navigation>Navigation Options (button) and display all Hidden and System objects.

  5. #5
    NTC is offline VIP
    Windows 7 64bit Access 2013
    Join Date
    Nov 2009
    Posts
    2,392
    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 Virtually Inert Person
    Windows 7 32bit Access 2007
    Join Date
    Jun 2014
    Location
    Ontario, Canada
    Posts
    12,737
    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.
    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. Password protection
    By elico in forum Programming
    Replies: 7
    Last Post: 03-27-2016, 04:35 PM
  2. Reports Security Protection
    By mussy in forum Security
    Replies: 3
    Last Post: 06-28-2013, 01:58 PM
  3. Replies: 7
    Last Post: 03-12-2012, 09:18 AM
  4. Password protection
    By peshonzi in forum Forms
    Replies: 1
    Last Post: 07-07-2011, 04:09 AM
  5. help please. i need basic access privacy/protection ideas
    By helpporfavorplz in forum Security
    Replies: 1
    Last Post: 02-20-2010, 05: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
  •  
Other Forums: Microsoft Office Forums