Results 1 to 6 of 6
  1. #1
    d9pierce1 is offline Expert
    Windows 10 Access 2016
    Join Date
    Jan 2012
    Location
    Oklahoma
    Posts
    754

    splitting db general question

    Hi all,
    Getting ready to split a db and have looked at a couple that have linked tables. OK, what i dont understand is how do you hide the tables so users cant see them? Your data is not really protected if you can access
    the linked tables, they can see the data, can get into design mode, and change data. This doesnt make sense to me. Must be something that wont allow them to see, edit, design, or do anything with the tables

    Thanks
    Dave

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    put in this code into a module, then in the startup macro AUTOEXEC,
    add RUNCODE , HideDB()
    ..then open your main menu

    this will hide the tables/queries.
    or
    uses the Lock Unlock db app (on this site) to hard lock users out of design mode, table view, etc.

    Code:
    Public Function HideDB()
      DoCmd.SelectObject acTable, , True
      DoCmd.RunCommand acCmdWindowHide
    end sub

  3. #3
    isladogs's Avatar
    isladogs is offline MVP / VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jan 2014
    Location
    Somerset, UK
    Posts
    5,954
    There are various approaches
    1. You can hide any Access object so its not visible in the nav pane...but that is easily reversed using Navigation options to show hidden objects.
    2. You can also deep hide tables so they cannot be viewed in the navigation pane at all...but that's overkill for your needs...and it can't be done for queries anyway.
    3. The best solution is to lock down your database so the navigation pane and ribbon are both hidden. Users only interact with your app using forms.
    For more details, see http://www.mendipdatasystems.co.uk/i...y-2/4594571073

    BTW the design of linked tables cannot be modified from the FE ... other than by using code
    Last edited by isladogs; 09-21-2020 at 01:42 PM.
    Colin, Access MVP, Website, email
    The more I learn, the more I know I don't know. When I don't know, I keep quiet!
    If I don't know that I don't know, I don't know whether to answer

  4. #4
    wvmitchell is offline Novice
    Windows 10 Access 2016
    Join Date
    Aug 2020
    Posts
    24
    Here is a link to an article I wrote some time ago, it allows you to set the startup properties to enable/disable various items.
    http://wvmitchell.com/tips/Security%...20database.htm
    HTH

  5. #5
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    Lock app to disable users from bypassing menus, getting in vba, etc.
    Attached Files Attached Files

  6. #6
    d9pierce1 is offline Expert
    Windows 10 Access 2016
    Join Date
    Jan 2012
    Location
    Oklahoma
    Posts
    754
    Thank you all, I have some great stuff to review!
    You are all awsome!
    Dave

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

Similar Threads

  1. General Question
    By Gregm66 in forum Access
    Replies: 2
    Last Post: 10-05-2016, 11:10 AM
  2. General tracking question.
    By Homegrownandy in forum Access
    Replies: 9
    Last Post: 09-04-2015, 07:59 AM
  3. General totals question
    By brownk in forum Database Design
    Replies: 8
    Last Post: 05-18-2012, 09:16 AM
  4. General Question
    By notadbadmin in forum Access
    Replies: 3
    Last Post: 08-03-2011, 08:03 PM
  5. General question
    By dollygg in forum Access
    Replies: 7
    Last Post: 12-11-2009, 05:13 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