Results 1 to 4 of 4
  1. #1
    2 Star Lounger
    Join Date
    Jan 2001
    Posts
    113
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Secured Database

    I had a little panich when I was testing my secure database after setting in on the shared drive. I double clicked the .mdb file instead of using the shortcut (which includes the /wrkgrp switch)and it opened without the logon screen. This was not what I expected. It opened using the system.mdw workgroup file which included user & Admin.

    Is this correct? This means that anybody that has access to the shared folder can view all the data.

    What do I need to do to prevent this?

    Thanks, Simon

  2. #2
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Secured Database

    That's exactly what it means, and it's the reason you remove all permissions from the Admin user in a secured database. You can also add some code to the database (both front and backend if it's split) that runs at startup and tests to see who the user is. If the user is Admin, it simply closes the application. They can still get around that if you leave the bypass key enabled, but if all permissions have been removed for Admin, they can't do anything.
    Charlotte

  3. #3
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Brisbane, Queensland, Australia
    Posts
    352
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Secured Database

    However, I think there is something about making sure there is an owner, other than Admin who has full permissions before you take away Admin's permissions. Otherwise you can never alter anything.
    David Grugeon
    Brisbane Australia

  4. #4
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Secured Database

    You're right, and I skated right over that in my response.
    Charlotte

Posting Permissions

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