Results 1 to 2 of 2
  1. #1
    data808 is offline Noob
    Windows XP Access 2010 32bit
    Join Date
    Aug 2012
    Posts
    727

    Password Login Forms

    I've searched online and have found some tutorials to do a login form with a userID and password. The userID and Password is stored in a table. However, they don't say how to lock this table from view to the user. If you hide the table thats ok I guess but if the user knows how to unhide the table containing all this confidential information, what is the point of having a userID or Password. I feel like there has to be a solution to this. The table can't just be hidden. Its needs to be locked and have a password to open it.



    I also should mention, I already know how to password encrypt the entire database which is not suitable for my situation because I will be having a lot of different users using this database. I also know about front end and back end. Password encrypt the back end then link the table to the front end but once you link it to the front end, the front end stores the password and will no longer require a password to view the table. So my question is extremely specific. How do you lock just the table from view? Not just hide it?

  2. #2
    ItsMe's Avatar
    ItsMe is offline Sometimes Helpful
    Windows 7 64bit Access 2010 32bit
    Join Date
    Aug 2013
    Posts
    7,862
    This thread is similar to your question in the other thread you started.
    https://www.accessforums.net/access/...rms-41721.html

    Introduce some VBA to hide everyrthing and then publish your FE as an executible. Here is some info on locking down a file using VBA.
    https://www.accessforums.net/security...lbar-3536.html

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

Similar Threads

  1. Login Form with Password
    By data808 in forum Programming
    Replies: 1
    Last Post: 02-12-2014, 01:06 PM
  2. Password ### login
    By buckwheat in forum Access
    Replies: 5
    Last Post: 09-10-2013, 11:54 AM
  3. Replies: 1
    Last Post: 08-23-2013, 10:15 AM
  4. Problem with User Login and Password
    By sk88 in forum Access
    Replies: 3
    Last Post: 12-16-2011, 08:11 AM
  5. Login/Password Code not working
    By eww in forum Programming
    Replies: 3
    Last Post: 09-21-2010, 10:49 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