Re: Security Wizard Locked ALL Db's

anonymous_at_discussions.microsoft.com
Date: 07/11/04

  • Next message: wysiwyg: "Converting 97 to 2002" 
    Date: Sun, 11 Jul 2004 07:11:12 -0700

    Graham,

    Is there a way to get my system back to normal WITHOUT
    all of the security ?

    Can I just delete the security.mdb and have the machine
    and ALL of my databases back to normal ?

    Like I said in my original message - I'm asked for a
    Username/Password for any access database I try to open
    on this machine. I just want all of this security off
    everything (no more prompts for anything) and then I'll
    start over.

    Thank you! This is my first attempt at doing security on
    an access database and I've got a lot to learn! <grin>

    >-----Original Message-----
    >Bob,
    >
    >It seems you took all the right actions - except one!
    You forgot to create a
    >new Workgroup file before you started.
    >
    >At this point, you have two options.
    >
    >The first option (and one I know you're not going to
    like), is to remove all
    >the security you've just added, then start again (making
    sure to create a
    >new workgroup file before you start).
    >
    >The second option is to make a copy of the current
    System.mdw file, rename
    >it, then fire up the secured database using it.
    >1. Open any code module in the secured database.
    >2. Display the Immediate window (View --> Immediate
    Window).
    >3. In the Immediate Window, enter the following, then
    hit the Enter key:
    > ?dbengine.SystemDB
    > You should get something like this:
    > C:\PROGRA~1\COMMON~1\System\SYSTEM.MDW
    > This is the path to the current System.mdw file (the
    one you're about to
    >copy).
    >4. Enter the following in the Immediate window, then hit
    the Enter key:
    > ?access.SysCmd(acSysCmdAccessDir)
    > You should get something like this:
    > C:\Program Files\Microsoft Office\Office\
    >5. Close Access.
    >6. Copy the System.mdw file to a place where all users
    can get at it.
    >7. Rename the copied System.mdw file to something else
    (typically, this
    >would be the same name as the mdb file).
    >8. Make a shortcut to your mdb file:
    > a). Open Windows Explorer.
    > b). Locate your database (*.mdb).
    > c). Right-click the mdb file, and select Create
    Shortcut from the
    >context menu.
    > d). Move the newly-created shortcut to your Desktop.
    >9. Right-click the shortcut, and select Properties from
    the context menu.
    >10. Select the Shortcut tab.
    >11. Place the cursor at the far left of the Target
    field, then enter the
    >path you got in Step 4. Then append "msaccess.exe", and
    enclose it in
    >double-quotes. It should look like this:
    > "C:\Program Files\Microsoft
    Office\Office\msaccess.exe"
    >12. Make sure there's a space between what was already
    in the Target field,
    >and the path you added in Step 10.
    >13. Place the cursor at the far-right of the Target
    field, then enter
    >"/wrkgrp", a space, plus the path you to the new
    (renamed) Workgroup file,
    >and enclose it in double-quotes. It should look like
    this:
    > /wrkgrp "C:\myDatabase\myDb.mdw"
    >14. The whole Target string should look like this:
    > "C:\Program Files\Microsoft
    Office\Office\msaccess.exe"
    >"c:\myDatabase\myDb.mdb" /wrkgrp "C:\myDatabase\myDb.mdw"
    >15. Click OK.
    >16. Just to check that all went well, double-click the
    shortcut, and enter
    >your username and password.
    >17. Close Access.
    >18. Remember in Step 6 when you copied the mdw file?
    Well now you have to
    >replace the original one with something that doesn't
    have security in it.
    >Pinch one from somebody else in the office, and simply
    copy it over the top
    >of the one whose address was discovered in Step 3.
    >
    >Now every time you want to use this database, you'll
    have to use the
    >shortcut, and every other user who wants to use it will
    have to do likewise
    >(so you'll have to create a shortcut on their Desktops
    too). Don't get too
    >upset, you would have to do this anyway - even if you
    hadn't stuffed up the
    >original system.mdw. This is the way Access security
    works.
    >
    >Got all that?? <g d&r>
    >
    >Regards,
    >Graham R Seach
    >Microsoft Access MVP
    >Sydney, Australia
    >
    >Microsoft Access 2003 VBA Programmer's Reference
    >http://www.wiley.com/WileyCDA/WileyTitle/productCd-
    0764559036.html
    >
    >
    >"Bob" <anonymous@discussions.microsoft.com> wrote in
    message
    >news:294b901c46536$923f7c50$a501280a@phx.gbl...
    >> After running the Security Wizard to "Secure" a single
    >> database I have found ALL of the Access databases I try
    >> to open LOCKED!
    >>
    >> I'm prompted to enter a Username and Password for every
    >> db, even db I did not protect.
    >>
    >> Is this by design ?? Can I rool back the system to a
    >> prior point with the system restore feature to remove
    >> this ??
    >>
    >> I have databases on a server and other users are able
    to
    >> access just fine, but everything from this workstation
    >> wants a userid/password.
    >>
    >> Thank you for any assistance!
    >
    >
    >.
    >

  • Next message: wysiwyg: "Converting 97 to 2002"

    Relevant Pages

    • Re: secured database with Access 2002 or greater on network
      ... Not sure what the /wrkgrp goes with the database or the security ... Path of database located on F: ... you'll need to modify the shortcut so that the path to Access reflects ... in the same folder as the mdb. ...
      (microsoft.public.access.security)
    • Re: Multi user enviroment - part II
      ... Let's say for the sake of discussion that I have a multi-user database ... Give the new security file an ID, note the User, Organization, and ID ... MyAppFolder with the workgroup information file used when establishing ... "You can create a shortcut and enter this syntax as the target of the ...
      (comp.databases.ms-access)
    • Re: How to add 3 levels of access to a database
      ... You must follow the steps in Section 1 of the security FAQ exactly. ... you won't have a secured database. ... secure your database ... ... your shortcut - what's the value in the shortcut's Target setting? ...
      (microsoft.public.access.security)
    • Re: i give up...please tell me how to remove security
      ... Access Security: www.ltcomputerdesigns.com/Security.htm ... > When I copied the database over I also copied the "secured.mdw" file and ... > shortcut that I used to open it. ... I changed the workgroup in the target of the shortcut to refer to this ...
      (microsoft.public.access.security)
    • Re: /wrkgrp switch being ignored
      ... I took out the path to the database as I was trying to simplify the shortcut ... > You don't have the path to your database identified in your target. ... >> I'm trying to have Access join a specific Workgroup upon startup by using ...
      (microsoft.public.access.security)
    Loading