Results 1 to 2 of 2
  1. #1
    nancypez is offline Novice
    Windows 8 Access 2013
    Join Date
    Apr 2015
    Posts
    2

    Hide all tables and queries from everyone but me

    I have tables, queries, forms and reports all set up in Access 2013. I have a usertbl set up for people to log into a form.

    I would like to hide and lock everything but the form that the user logs into in the database so no one can see the other data except me. Is there a way to do this?

    I would be of great assistance for some help with this. I have worked with databases but have never tried to work with security features.



    Any and all information would be greatly appreciated!!!!!!

  2. #2
    June7's Avatar
    June7 is online now VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,822
    Lot of security features were dropped with Access 2007. There are some option settings - however, holding down the shift key when opening db will override.

    File > Options > Current Database > make choices (hide navigation pane, disable shortcuts, disable menu, disable special keys).

    This is a common topic in forum.

    https://www.accessforums.net/access/...ess-44040.html
    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.

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

Similar Threads

  1. Replies: 3
    Last Post: 01-08-2014, 06:37 PM
  2. Replies: 1
    Last Post: 03-08-2012, 08:34 AM
  3. Turn off Ribbon and hide all tables
    By stryder09 in forum Access
    Replies: 1
    Last Post: 04-11-2011, 03:10 AM
  4. Hide tables from general users
    By stryder09 in forum Access
    Replies: 0
    Last Post: 03-28-2011, 11:13 AM
  5. queries or tables?
    By ejohns in forum Reports
    Replies: 7
    Last Post: 07-27-2009, 11:31 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