Unsecure a secured Access database

Posted on 2004-11-17
Last Modified: 2006-11-17
I used user level security wizard to secure one database which is accessed by several users over the network. Problem is that all the other unsecured Access databases on the network drive are now asking for passwords. What could be the problem? Even the backup database is also asking for a password. Can i unsecure the database - how best can i solve this problem?
Question by:hchibuda
    LVL 14

    Expert Comment

    the things is that the access application now uses the workgroup file you created when securing the database as the default workgroup file.  what you need to do is store your workgroup file in a specific place and open the secure database with a shortcut that specifies the database *and* the workgrop file to use.

    then, you open the workgroup manager (normally it's here: C:\Program Files\Microsoft Office\Office\1033\WRKGADM.EXE), click "join" and select the default database (usually C:\Program Files\Common Files\System\SYSTEM.MDW).  from then on, access will not ask you for passwords anymore for unsecured databases.

    LVL 14

    Accepted Solution

    btw: the syntax for "target" in the shortcut to open the secured database is the following:

    "C:\Program Files\Microsoft Office\Office\MSACCESS.EXE" /WRKGRP "C:\path\to\myworkgroup.mdw" "C:\path\to\mydatabase.mdb"


    Featured Post

    Find Ransomware Secrets With All-Source Analysis

    Ransomware has become a major concern for organizations; its prevalence has grown due to past successes achieved by threat actors. While each ransomware variant is different, we’ve seen some common tactics and trends used among the authors of the malware.

    Join & Write a Comment

    Experts-Exchange is a great place to come for help with solutions for your database issues, and many problems are resolved within minutes of being posted.  Others take a little more time and effort and often providing a sample database is very helpf…
    Introduction The Visual Basic for Applications (VBA) language is at the heart of every application that you write. It is your key to taking Access beyond the world of wizards into a world where anything is possible. This article introduces you to…
    Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…
    Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

    745 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    16 Experts available now in Live!

    Get 1:1 Help Now