Re: Locked myself out as administrator

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Try logging in as 'administrator' and leave the password blank.

--
Joan Wild
Microsoft Access MVP

Mike G wrote:
> "Joan Wild" wrote:
>
>>>
>>> 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
>>
> Yes Joan I can get in but I can only enter data in the forms. I am
> unable to run queries or generate reports. Thats because the only
> privileges I extended the group was data entry.
>
> I had tried earlier to create a new data base and import the data
> from the "old" database without luck. I will try again tommorrow and
> also let you know the names of the files that do allow me entry.
> Thanks.
> Mike


.

Relevant Pages

  • Re: Help restoring permission
    ... Joan Wild ... Microsoft Access MVP ... no read permission on "MSysAccessObjects'. ... I haven't changed the administrator name or password and the ...
    (microsoft.public.access.security)
  • Re: renamed mdb > dat > email with hotmail > now I cant open it
    ... Joan Wild ... Microsoft Access MVP ... Jesper Fjølner wrote: ... you only saw that message because you were an administrator ...
    (microsoft.public.access.security)
  • Re: permissions for link table manager
    ... The security FAQ has a section with all the information you need on this. ... Joan Wild ... Microsoft Access MVP ...
    (microsoft.public.access.security)
  • Re: More security questions
    ... Joan Wild ... Microsoft Access MVP ... have permissions to do anything. ... Usernames/passwords/group membership are stored in the mdw. ...
    (microsoft.public.access.security)
  • Re: More security questions
    ... Joan Wild ... Microsoft Access MVP ... have permissions to do anything. ... Usernames/passwords/group membership are stored in the mdw. ...
    (microsoft.public.access.security)