Re: Locked myself out as administrator



"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: Yonder Mountain String Band(ndc)
    ... If necessary call security over to alleviate the problem. ... folks at our shows are respectful and mean no harm, ... but people were throwing stuff at Phil and Joan a week ago ... flung a water bottle that wizzed by Joan's head; ...
    (rec.music.gdead)
  • Re: Bulletproofing database with .mde file
    ... You persist in suggesting that I do not understand what Joan is ... > experimented with the security and built tools to automate the recovery ... > tools will know the vulnerabilities and how to overcome them to get at the ... > she reads your posts. ...
    (microsoft.public.access.security)
  • Re: Bulletproofing database with .mde file
    ... You persist in suggesting that I do not understand what Joan is ... > experimented with the security and built tools to automate the recovery ... > tools will know the vulnerabilities and how to overcome them to get at the ... > she reads your posts. ...
    (microsoft.public.access.gettingstarted)
  • Re: How to prevent importing tables
    ... If Joan's suggestion can be broken by only a select few ... Access Security has always been, and will continue to be security by ... Joan Wild ... Microsoft Access MVP ...
    (microsoft.public.access.security)
  • Re: How to apply security to a column in a table?
    ... Thanks, Joan, for your response. ... I am not an expert in Jet security by any ... but are you suggesting that I can somehow "lock down" the tables ...
    (microsoft.public.access.security)
Loading