Re: Locked myself out as administrator



"Joan Wild" wrote:

> 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

Joan,
I tried your recommendations and several of the mdw files open the database
after I log on as a user, however none of them give me full administrative
priviliges. This is despite the fact that when I look under "administrator"
it has my name and shows me as getting full privileges. I've tried entering
"administrator" in the log on box and tried several of the passwords I
normally use and no luck....I'm at wits end. Thanks Mike



>
>
.

Relevant Pages

  • Re: where are posts from last week?
    ... along with a message from Joan Wild. ... create a desktop shortcut that will use the target that I described to you. ... It will open and show you the 'path to msaccess.exe' in the target line. ...
    (microsoft.public.access.security)
  • Re: Point to correct .MDW file
    ... Then created a shortcut to my application, ... "Joan Wild" wrote: ... > The only way to do it is to give them a desktop shortcut that has a target ... > If they all put it in the same folder, and they all installed Access to the ...
    (microsoft.public.access.security)
  • Re: Help - locked out of database
    ... dang...I was sure I could get in on a planner computer-I can't. ... only the shortcut is different. ... "Joan Wild" wrote: ... It's possible that you don't have enough Windows permission on this new folder. ...
    (microsoft.public.access.security)
  • Re: locked out....PLEASE HELP!!!
    ... and also a shortcut for them. ... >Joan Wild ... without viewing any of my ... >designs and only allowing reporting for my manager and ...
    (microsoft.public.access.security)
  • Re: applied security and cannot access database
    ... Luckily I did find the shortcut which allowed me to open it. ... "Joan Wild" wrote: ... That is the unsecured version of your database. ... >> I can open up the BAK file but cannot save it. ...
    (microsoft.public.access.security)