none
Remove Access Security Set-Up RRS feed

  • Question

  • Hi All.  I make a rookie mistake.  Last fall I ran the security wizard in Access 2003 before I was prepared.  I would like to change back to the default settings, study up and then set security appropriately.

    On the old discussion board I found and tried these steps---------------

    You can remove security (from within Access 2003) by:

    1. First, log in as a member of the Admins Group, or as the owner of the
    database.

    2. Grant full permissions to every object, including the database object
    itself, to the Users Group.

    3. Close the database and the Access application.

    4. Use the workgroup administrator (which should be at: C:\
    Windows\System32\Wrkgadm.exe) to make sure you are joined to the
    system.mdw that ships with Access. (which should be at: C:\
    Windows\System32\system.mdw)

    5. Reopen Access after joining the changed system.mdw and create a new
    database.

    6. Import everything from your old database into the new, unsecured one.

    7. That's it, now copy that database to  Access 2007.
    --
    Arvin Meyer, MCP, MVP
    ----------------------------------

    I did fine up until step #7.  Then I got this message: "You don't have
    permission to copy tblBudgets".  I switched back to the mdw file with the
    security info on it and rechecked that I had granted full permissions to the
    user group, which I had.  Then I switched back to the default mdw file to try
    again and got the same message.

    Also, when attached to the default mdw file I can open up the database
    without login or password (yay!) but cannot do anything (boo!).  I get this
    message "Could not read definitions; no read definition permissions for table
    or query ‘tblBudget’".  When I switch back to the mdw file with the security
    info on it I can function as normal. 

    Lastly, I did a file search for mdw files on my computer and it found 25 of
    them.  It appears that each user in my department has an mdw file at
    C:\Documents and Settings\xxUSERNAMExx\Application Data\Microsoft\Access.  Is
    there a specific default mdw file I should use?

    Any help is greatly appreciated!  Thanks in advance :D
    Stacey

    Thursday, June 3, 2010 9:41 PM

Answers

  • Stacey

    First of all I never "join" a workgroup except to make a new one. I open secured DBs with shortcuts that include teh /wrkgrp switch. That way I am always in the System workgroup.

    Join the default System.MDW as Arvin said in step #4.

    Open the secured DB as an Admins member using the /wrkgrp switch for the DB's MDW file. A shortcut target would look like (all one line):

    "C:\Program Files\Microsoft Office\Office11\msaccess.exe" "C:\Databases\MysecuredDB.MDB" /wrkgrp "C:\Databases\MyWorkGroup.MDW"

    Grant full permissions to all objects (which is probably how it already is for an Admins member.

    Close the DB and open a new DB that is unsecured.

    Close it and re-open the secured DB using the above mentioned /wrkgrp switch. I export all objects to the new DB (You can use my ExportAll at http://thatlldoit.com/utilsaddins.aspx add-in to do it all at one time).

    Now you should be able to open the enw DB and it will be free of all security.


    Bill Mosca www.ThatllDoIT.com
    Friday, June 4, 2010 5:13 PM