Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

Access Workgroup Security

Discussion in 'Information Technology' started by Susan, Jul 28, 2006.

  1. Susan

    Susan
    Expand Collapse
    Guest

    Hi all,
    I have an Access 97 database that restrics the users through a user
    level workgroup file. It works well and good for this particular
    application.
    The problem occurs when I try to open other databases from Access97 .
    I am being asked for the Name and Password ( from the workgroup I
    created) . It looks like , once I set up a workgroup file, Access will
    always refer its security based on the the currently joined workgroup.

    I want to apply this workgroup security only to the application I am
    currently developing, not to all the Access 97 databases.

    Does anyone know any solution .
     
  2. Loading...


  3. Paul Overway

    Paul Overway
    Expand Collapse
    Guest

    Rejoin the default system.mdw workgroup file. Then use a shortcut with the
    necessary command line parameters, i.e.,

    "path to msaccess.exe" "path to your.mdb" /wrkgrp "path to your.mdw"

    --
    Paul Overway
    Logico Solutions, LLC
    www.logico-solutions.com


    "Susan" <priyapalmfield@gmail.com> wrote in message
    news:1151500555.151504.26570@p79g2000cwp.googlegroups.com...
    > Hi all,
    > I have an Access 97 database that restrics the users through a user
    > level workgroup file. It works well and good for this particular
    > application.
    > The problem occurs when I try to open other databases from Access97 .
    > I am being asked for the Name and Password ( from the workgroup I
    > created) . It looks like , once I set up a workgroup file, Access will
    > always refer its security based on the the currently joined workgroup.
    >
    > I want to apply this workgroup security only to the application I am
    > currently developing, not to all the Access 97 databases.
    >
    > Does anyone know any solution .
    >
     
  4. Rick Brandt

    Rick Brandt
    Expand Collapse
    Guest

    Susan wrote:
    > Hi all,
    > I have an Access 97 database that restrics the users through a user
    > level workgroup file. It works well and good for this particular
    > application.
    > The problem occurs when I try to open other databases from Access97 .
    > I am being asked for the Name and Password ( from the workgroup I
    > created) . It looks like , once I set up a workgroup file, Access will
    > always refer its security based on the the currently joined workgroup.
    >
    > I want to apply this workgroup security only to the application I am
    > currently developing, not to all the Access 97 databases.
    >
    > Does anyone know any solution .


    As you have seen the workgroup affects the "session". It is not linked to
    any particular file. The bascis are this...

    Access ALWAYS uses a workgroup file.

    If you don't specify a workgroup as a command line argument your default
    workgroup as defined in the Workgroup Administrator Utility is used.

    If the workgroup being used has a password on the default user Admin then
    you are prompted to log in. If the default user Admin does not have a
    password then you are not prompted and are silently logged in as Admin.

    So...if you have made your default workgroup one that has a password on the
    Admin user then you are prompted every time you open Access. The file or
    files that you might decide to open are irrelevant at this point.

    Use the Workgroup Administrator tool to change your default workgroup back
    to System.mdw. Then create a shortcut for opening Access that includes your
    secure MDW file as a commnad line argument. When you use that shortcut you
    will be prompted. When you open Access any other way you will not be. The
    target of such a shortcut would be...

    "full path to MSACCESS.EXE" /wrkgrp "full path to MDW"

    By the way, you should find after doing the above that you cannot open your
    secured files unless you open Access using the special shortcut. If you can
    open them without using that shortcut, then you didn't apply security
    correctly.

    If you only have one secured file then a common practice is to also specify
    that file in the custome shortcut so that it automatically is opened. That
    syntax would be...

    "full path to MSACCESS.EXE" /wrkgrp "full path to MDW" "full path to MDB"

    A shortcut like this would then be supplied to all of your users so that you
    can also leave their default workgroup alone.

    --
    Rick Brandt, Microsoft Access MVP
    Email (as appropriate) to...
    RBrandt at Hunter dot com
     
  5. Jon Lewis

    Jon Lewis
    Expand Collapse
    Guest

    It sounds as though the default workgroupfile has been modified thus
    imposing the same log on security to all databases.

    To impose workgroup security on a specific database, run the Workgroup
    Administrator WRKGADM.EXE to create a new workgroup information file with
    the user and user group details you require.

    Create a shortcut to start your appication as follows:
    "C:\Program Files\MicrosoftOffice\Office\MSACCESS.EXE" "PathToYourMDB"
    /wrkgrp "PathToYourNewMDW.mdw"
    (Assuming Access has been installed to the default folders)

    Get an unmodified copy of the default system.mdw and replace your modified
    one with it.

    A search of this newsgroup will yield plenty of info on security in Access.

    HTH



    "Susan" <priyapalmfield@gmail.com> wrote in message
    news:1151500555.151504.26570@p79g2000cwp.googlegroups.com...
    > Hi all,
    > I have an Access 97 database that restrics the users through a user
    > level workgroup file. It works well and good for this particular
    > application.
    > The problem occurs when I try to open other databases from Access97 .
    > I am being asked for the Name and Password ( from the workgroup I
    > created) . It looks like , once I set up a workgroup file, Access will
    > always refer its security based on the the currently joined workgroup.
    >
    > I want to apply this workgroup security only to the application I am
    > currently developing, not to all the Access 97 databases.
    >
    > Does anyone know any solution .
    >
     
  6. Susan

    Susan
    Expand Collapse
    Guest

    great help !!! thats what i wanted ...thanks for the quick responses...
    Susan wrote:
    > Hi all,
    > I have an Access 97 database that restrics the users through a user
    > level workgroup file. It works well and good for this particular
    > application.
    > The problem occurs when I try to open other databases from Access97 .
    > I am being asked for the Name and Password ( from the workgroup I
    > created) . It looks like , once I set up a workgroup file, Access will
    > always refer its security based on the the currently joined workgroup.
    >
    > I want to apply this workgroup security only to the application I am
    > currently developing, not to all the Access 97 databases.
    >
    > Does anyone know any solution .
     

Share This Page