Re: Locked myself out as administrator

>
> 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

Well at least you can get in. Since you can see the permissions for
'administrator', that suggests that you do have administrative permissions.
Are you able to add you (as user) to the Admins Group?

Also which mdw files give you access?

Try this. Log in as you (as user); create a new mdb and see if you can
import all objects from your mdb. If you can then you (as user) will now
own all objects, however security will be removed from the mdb. If you can
get this far post back.

--
Joan Wild
Microsoft Access MVP


.

Relevant Pages

  • Re: Access 97 Permissions Issue
    ... Hey Joan - Never mind my last post/question. ... of the old programmer in one of the old MDW files. ... Likely because they aren't secured - the Users Group has permissions to the database. ... I was then able to log into the problematic MDB with my new ID. ...
    (microsoft.public.access.security)
  • Re: 5 access 2000 users and 1 AccessXP user
    ... > Making the user an administrator on the local machine worked for the case ... > it to th PC (it is an mde file). ... The back end is on a server running win2K ... locate the front end mdb file on the ...
    (microsoft.public.access.conversion)
  • Re: in query expression MSysAccounts.name. ERROR
    ... Use the Access WorkGroup Administrator to create and join ... Are you an administrator on your own laptop? ... > There were quite a few mdw files on the laptop. ...
    (microsoft.public.access.security)
  • Computer turns on with different user
    ... It is used with the user name "Joan" ... of the proper icons are on the desktop and it can't get into the LAN ... with that user name (Administrator). ...
    (microsoft.public.win2000.general)
  • Re: Access 2003 - Sicherheitseinstellungen lassen mich nicht mehr in meine Datenbank
    ... kannst Du mit dem Arbeitsgruppen Administrator (ist ... neue MDB anlegen) eine neue System.MDW anlegen und Dich mit der ... Keine E-Mails auf Postings in NGs senden! ...
    (microsoft.public.de.access)