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

    Password For Table Only


    Is there a way to put a password to open tables only? I have a form that many clerks will be using and I just don't want them to be able to open the table without a password.

  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,815
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  3. #3
    lfpm062010 is offline Competent Performer
    Windows 7 64bit Access 2010 64bit
    Join Date
    Oct 2013
    Location
    US
    Posts
    415
    I have not try this.

    The idea is "link tables with access files that is password protected". Wonder if that will work.

  4. #4
    data808 is offline Noob
    Windows XP Access 2010 32bit
    Join Date
    Aug 2012
    Posts
    727
    But isn't the table within the access file? Unless you mean put a password protection on the access file itself? But then it would just ask for a password when you open the file. Which would then give access to the tables anyway. I need something that can lock the table from view. The best solution I got at the moment is to hide the navigation pane or even hide the table itself but if someone that knows the options of access uses this, they will be able to find the tables.

  5. #5
    lfpm062010 is offline Competent Performer
    Windows 7 64bit Access 2010 64bit
    Join Date
    Oct 2013
    Location
    US
    Posts
    415
    I guess I did not explain clearly.

    The idea is that you have 2 (or more) Access databases (Access Files). You put the tables that you want to be protected by a password in one files (we call this "PROTECTACCESS"). You use the other access database (access file) to run your queries/forms/macros/reports (we will call this "RUNACCESS").

    In "RUNACCESS" file you link the tables from the "PROTECTACCESS" file. So, when you access the table that is linked, it should ask you for a password ("PROTECACCESS" password).

    I hope this will be clear.

  6. #6
    data808 is offline Noob
    Windows XP Access 2010 32bit
    Join Date
    Aug 2012
    Posts
    727
    Isn't that called frontend and backend databases? So the backend would be the PROTECTACCESS file and the frontend would be the RUNACCESS file. I tried this but when you link the table from PROTECTACCESS to RUNACCESS it won't allow you to do that because it has a password on it. So you need to use the import wizard to import the table from another Access file. I then used the "Link to the data source by creating a linked table" option. Which also states as a NOTE: If the source database requires a password, the password will be stored with the linked table. Meaning I won't be required to provide a password to open the linked table from the RUNACCESS file because it will be stored with the table and I have tried this and it lets me open the table no problem with no password. So this is not what I want for the user to have access to.

    Thanks for the help though.

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

Similar Threads

  1. Set password for table
    By uronmapu in forum Access
    Replies: 1
    Last Post: 08-01-2012, 11:24 AM
  2. Replies: 1
    Last Post: 06-22-2012, 08:05 AM
  3. Password protecting a table?
    By Celx in forum Security
    Replies: 2
    Last Post: 12-17-2011, 02:09 AM
  4. Replies: 2
    Last Post: 05-23-2011, 10:36 AM
  5. Username/Password From Table
    By mj-egerton in forum Programming
    Replies: 0
    Last Post: 04-03-2011, 04:46 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