Results 1 to 5 of 5
  1. #1
    New Lounger
    Join Date
    Sep 2005
    Posts
    6
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Secure or Split the DB (Access 2003)

    Which should be done first between a) splitting the DB by using the wizard or [img]/forums/images/smilies/cool.gif[/img] securing the database? Any suggestions?

  2. #2
    4 Star Lounger
    Join Date
    Jan 2002
    Location
    Brookings, South Dakota, USA
    Posts
    449
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Secure or Split the DB (Access 2003)

    I'd start with this post here <post#=516,107>post 516,107</post: > . There are other links within this thread which should/may answer your questions. My first inclination would be to split first, then secure.
    <IMG SRC=http://www.wopr.com/w3tuserpics/gdrezek_sig.jpg>
    "Those who dance are considered insane by those who can't hear the music" - George Carlin

  3. #3
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,623
    Thanks
    3
    Thanked 60 Times in 60 Posts

    Re: Secure or Split the DB (Access 2003)

    I agree with Gary - split it first. The back-end definitely should be secured, and it's easier to do when the database is already split.
    Wendell

  4. #4
    New Lounger
    Join Date
    Sep 2005
    Posts
    6
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Secure or Split the DB (Access 2003)

    The database is split, and I thought I had secured it on my PC. I uploaded the backend of the database to the network drive, and copied the front end to another user's machine. However, she could get into the database without having to go through the security prompt. What did I miss?

    I got the security setup, and tried to get her logged in with her id, but no matter what I tried, I could not get her logged into the system, although she was a user, rights, etc. What did I miss here?

    CONFUSED....

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

    Re: Secure or Split the DB (Access 2003)

    User-level security is based on two items:

    - The users and groups defined in a workgroup file (.mdw)
    - The permissions assigned to the users and groups in your database (.mdb or possibly .mde)

    You have probably created the users and their passwords in your default workgroup file System.mdw. This is not available to other users, they will open the database with their own unsecured workgroup file.

    You should do several things:
    - Take the default Admin user out of the Admins group.
    - Take away most or all permissions from Admin.
    - These two measures will ensure that someone who opens the database with an unsecured workgroup file will not be able to do much.
    - Copy your own System.mdw from your own hard disk (its default location is Cocuments and Settings<username>Application DataMicrosoftAccess) to a shared location, or give each user a local copy.
    - Rename the copy to for example Secured.mdw.
    - Create a shortcut that opens your database together with the secured workgroup file. The target of the shortcut looks like this, with the appropriate paths and file names substituted:

    "C:Program FilesMicrosoft OfficeOffice12MSAccess.exe" "serversharefolderFrontend.mdb" /wrkgrp "serversharefolderSecured.mdw"

    See The Secrets of Security on WendellB's website.

Posting Permissions

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