Results 1 to 6 of 6
  1. #1
    Lounger
    Join Date
    Jan 2001
    Location
    Victoria, Texas, USA
    Posts
    28
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Viewing Tables (2007)

    I have a database used in the office that is used to store required training for employees. The database is connected to a personnel file that contains confidential information such as SSN's, addresses, job grades, etc. that need to remain hidden to most employees. Another file was set up to allow individuals to look up their information and was set up so that they did not have a menubar and they had to know their SSN to look up their data. The problem is that some of the employees found out they could hold down the shift key while opening the database and have access to all the information in the tables. Consequently the privacy of information requirement has been broken so we can no longer allow individuals to view their training information. Is there some way to hide the tables so they cannot be viewed?
    Thanks in advance.
    Jim

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Viewing Tables (2007)

    You can use code to disable the Shift key as a means to bypass the startup options. See <post:=181,926>post 181,926</post:>.
    But someone who is handy with Access will still be able to get at the information, for example by creating a new database and linking to the tables in the protected database.

  3. #3
    Gold Lounger
    Join Date
    Jun 2001
    Location
    Crystal Beach, FL, Florida, USA
    Posts
    3,436
    Thanks
    1
    Thanked 34 Times in 34 Posts

    Re: Viewing Tables (2007)

    There are several things that can be done, but if done piece-meal they can be easily circumvented. I suggest you get Garry Robinson's book "Real World Microsoft Access Database Protection and Security". This will show you how to lockdown a database (without using Access security) so only an experience programmer will be able to get to get beyond what you want them to see.
    Mark Liquorman
    See my website for Tips & Downloads and for my Liquorman Utilities.

  4. #4
    Lounger
    Join Date
    Jan 2001
    Location
    Victoria, Texas, USA
    Posts
    28
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Viewing Tables (2007)

    Thanks Mark. Where is the best place to find the book you recommended.
    Jim

  5. #5
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Viewing Tables (2007)

    For example at Amazon.com: Real World Microsoft Access Database Protection and Security: Garry Robinson: Books, but large or specialized bookshops may well have it in stock too.

  6. #6
    Gold Lounger
    Join Date
    Jun 2001
    Location
    Crystal Beach, FL, Florida, USA
    Posts
    3,436
    Thanks
    1
    Thanked 34 Times in 34 Posts

    Re: Viewing Tables (2007)

    I think you can find it at most of the bigger sites: bn.com, amazon.com, etc. I highly recommend it; what you learn in the first 2 chapters will more than cover the cost!
    Mark Liquorman
    See my website for Tips & Downloads and for my Liquorman Utilities.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •