Welcome to SPN

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

Sign Up Now!

Removing workgroup security

Discussion in 'Information Technology' started by Philip, Nov 3, 2005.

  1. Philip

    Philip
    Expand Collapse
    Guest

    We recently added workgroup security to our database due to the amount of
    people that were using, i.e. to have more control.

    Now we realise that it was properly a step too far and has caused other
    proplems such as external printers and other software that linked in to our
    database.

    How do we remove the workgroup security completely, i.e. not be prompted for
    user id and passwords etc.

    Thanks
     
  2. Loading...


  3. Wayne Morgan

    Wayne Morgan
    Expand Collapse
    Guest

    For the other items connecting to the database, you can create a DSN for
    them to connect to. The security information can be entered into the DSN.

    To remove the security, the easiest way may be to create a new, blank
    database and import everything into it. The security won't follow the
    import. Remember to open the code editor and do a compile after doing the
    import. You may have to set References in the code editor before it will
    compile without errors (Tools|References). This will depend on what
    References you've used in your database. Just compare the References
    settings in the new database to the current one. You will need to do this
    for the front-end and the back-end file if the security has been applied to
    each of them.

    --
    Wayne Morgan
    MS Access MVP


    "Philip" <Philip@discussions.microsoft.com> wrote in message
    news:3B5B5AD3-6DF1-461C-A662-8F58CDF4EF07@microsoft.com...
    > We recently added workgroup security to our database due to the amount of
    > people that were using, i.e. to have more control.
    >
    > Now we realise that it was properly a step too far and has caused other
    > proplems such as external printers and other software that linked in to
    > our
    > database.
    >
    > How do we remove the workgroup security completely, i.e. not be prompted
    > for
    > user id and passwords etc.
    >
    > Thanks
     

Share This Page