Results 1 to 6 of 6
  1. #1
    2 Star Lounger
    Join Date
    Feb 2001
    Location
    San Francisco, CA, USA
    Posts
    184
    Thanks
    0
    Thanked 0 Times in 0 Posts

    How secure is my database? (2002)

    Well, I think I finally have my database secure from prying eyes. I deselected all the startup options so the user has to go to the splash screen switchboard and can't open up the database window or sneak in from the menu bar menu's.
    I deabled the shift key as recommended in this forum by MarkD so these security measures can't be bypassed and everything seems secure. Is it?
    Frank

  2. #2
    Silver Lounger
    Join Date
    Jan 2001
    Location
    Indianapolis, Indiana, USA
    Posts
    1,862
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: How secure is my database? (2002)

    If you want to post a copy of it I'm sure some of us could give it a torture test for you! <img src=/S/evilgrin.gif border=0 alt=evilgrin width=15 height=15>

  3. #3
    2 Star Lounger
    Join Date
    Feb 2001
    Location
    San Francisco, CA, USA
    Posts
    184
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: How secure is my database? (2002)

    Hi Mark,
    I tried previously to post a screen shot and I got an error of "internal server error."
    The app now is about 6 meg,
    If you can just imagine it. It opens with a switchboard that when buttons are pushed you go to various imput forms etc. Is there anyway to defeat this security and get to the database objects?
    From the Switchboard you can't get to the database window or use the shift key.
    I do want to go to the next layer of security and use database security wizard but I have to see my dragon-lady client tomorrow who has threatened that she will go to the professor to finish off a few bugs I have and not let me get paid for the increased functionaliy i've been adding.
    Well the guys on Wood's Lounge are light-years ahead of any "Professor!"
    Frank <img src=/S/pirate.gif border=0 alt=pirate width=22 height=18>

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

    Re: How secure is my database? (2002)

    If you haven't applied user-level security or a set a database-level password, people will still be able to import all objects (tables, queries, forms etc.) from your database into another database...

  5. #5
    Bronze Lounger
    Join Date
    Nov 2001
    Location
    Arlington, Virginia, USA
    Posts
    1,394
    Thanks
    0
    Thanked 3 Times in 3 Posts

    Re: How secure is my database? (2002)

    An additional note concerning disabling Shift Bypass Key: A sneaky, devious, shiftless individual can disable the Shift Bypass property from another database by using code similar to that used to set property within same database, if they are knowedgeable enough. The only way to prevent them from doing this is to either implement Access security or set database password. If the Security Wizard is still giving you a hard time, at a minimum set a database password, which provides some limited protection. As HansV pointed out, w/o security or password users will be able to import objects into another database. Be advised that database passwords are stored in unencrypted form and are not hard to crack by determined individuals. Recommend creating password with mix of upper/lower case characters, numbers, and symbols (some symbols can't be used); password can be 1-20 characters in length and are case-sensitive. See Help for more details.

    Note however that if you provide your users with database password so they can open database, they will be able to use password to bypass some security measures as described above. For more robust security you'd have to implement User-Level Security for database.

    HTH

  6. #6
    Silver Lounger
    Join Date
    Jan 2001
    Location
    Indianapolis, Indiana, USA
    Posts
    1,862
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: How secure is my database? (2002)

    I think your problem with the screenshot is the filesize limit (see attachment). As I said before about screenshots, be sure to crop so it only shows the desired parts of the screen - AND be sure to optimize the image (to make it a smaller filesize).

    Also, if you're thinking of posting a databse (MDB file), you'll need to do several things:
    1) Compact the database from within Access (Tools - Database Utilities - Compact and repair)
    2) Create a ZIP file with the database - this usually squeezes the filesize up to 400%

    Hope this helps
    Attached Images Attached Images

Posting Permissions

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