Re: Locked myself out as administrator

No Mike, create a desktop shortcut.

Right-click on your desktop and choose New, Shortcut.

In the dialog, click on browse and browse to the location of msaccess.exe
(C:Program Files\Microsoft Office\Officexx\msaccess.exe) (xx may be 10, 11
or nothing depending on version)
Then click Finish.

Now right-click the shortcut that was created and click on Properties.
You'll be on the Shortcut tab and the Target textbox will be selected.
You'll see the "path to msaccess.exe" is already there. Click at the end of
that and add "path to your secure mdb" /wrkgrp "path to mdw" (substituting
the correct paths to your files).

Once you have this one done, copy and paste it eight times on your desktop.
Then edit each one (as above) and change the name of the mdw to reflect each
of the mdw files you found.


--
Joan Wild
Microsoft Access MVP

Mike G wrote:
> "Joan Wild" wrote:
>
>>
>> Mike G wrote:
>>>
>>> Well I originally used the Tools, security, to delete the old
>>> students and then I went through the security Wizard to add the new
>>> students.
>>
>> Well you should have just used the Tools, security, Accounts to
>> create the new ones as well.
>>
>>> Yes thats what I meant, I ran the security wizard again.
>>> Well I figured since its the Wizard, it could figure out what was
>>> wrong
>>
>> A wizard just does a series of steps for you; you give it far too
>> much credit.
>>
>>
>>> Joan I have the following MDW files on the computer, I've
>>> included the size and date modified
>>> System1.mdw 104KB 1/13/2004
>>> System2.mdw 104KB 8/14/2005
>>> Secured.mdw 172KB 7/24/2003
>>> Secured.mdw 412KB 8/5/2005
>>> Secured1.mdw 112KB 8/3/2005
>>> Secured2.mdw 112KB 8/3/2005
>>> Secured3.mdw 112KB 8/4/2005
>>> tcdb.mdb.mdw 104KB 8/5/2005
>>> tcdbperf.mdb.mdw 104 KB 8/5/2005
>>>
>>> I think some of these must have been generated when I made my futile
>>> attempts to fix the problem.
>>
>> I agree. Everytime you ran the security wizard, it created a new
>> workgroup file, which is what you don't want. Do not run it again.
>>
>> It would have been helpful to also see the full paths to these
>> files. What I would do is create nine desktop shortcuts.
>
> Joan , the full path to the files is
> C:\Documents and Settings\mgallagher\application
> data\Microsoft\Access
>
>
>> Put the following in the target of each:
> Sorry joan, forgive me...what do you mean by "target"?
>
>> "path to msaccess.exe" "path to your secure mdb" /wrkgrp "path to
>> mdw" Substitute the correct paths in the above, and for each
>> shortcut change the path to mdw to one of the ones listed above.
>
> I'm not really sure what you mean by the above....do I just enter
> the mdw location at the end of path I just showed you above?
>
>> Then open each one, logging in as you (as user) until you find the
>> one that lets you edit your database and add/remove users (gives you
>> full administrative abilities).
>> Once you've found it, I would copy the other eight mdw files to
>> CD/floppy, and then delete them from your computer.
>>
>> Do not run the security wizard again. Just use the Tools, Security,
>> Accounts menu to add and delete users.
>>
>>
>> --
>> Joan Wild
>> Microsoft Access MVP


.

Relevant Pages

  • Re: Security not clicking
    ... You do not create a shortcut on the network. ... Copy the backend to the server. ... Copy the secure mdw to the server. ...
    (microsoft.public.access.security)
  • RE: Workgroup Security
    ... I am going to make an .mde out of this database. ... Did you set an Admin Password in your new mdw? ... When you launch the shortcut does it ask you to authenticate with your ... use it for that mdb. ...
    (microsoft.public.access.security)
  • RE: Workgroup Security
    ... I am going to make an .mde out of this database. ... Did you set an Admin Password in your new mdw? ... When you launch the shortcut does it ask you to authenticate with your ... use it for that mdb. ...
    (microsoft.public.access.security)
  • Re: Security not clicking
    ... Copy the secure mdw to the server. ... If the wizard created a desktop shortcut for you on your PC, ... necessary) to reflect the path to the frontend on your c: ...
    (microsoft.public.access.security)
  • RE: Workgroup Security
    ... Did you set an Admin Password in your new mdw? ... When you launch the shortcut does it ask you to authenticate with your ... If you are checking the Workgroup Administrator, ... When I open database via shortcut it is still referencing the original ...
    (microsoft.public.access.security)