Re: Lost Permission

From: Joan Wild (jwild_at_nospamtyenet.com)
Date: 06/19/04 

Date: Sat, 19 Jun 2004 10:12:52 -0400

OK, that means that the password for the 'Admin' user has been set to
nothing (null). Therefore you get no login prompt. So Access is opening
and silently logging you in as Admin, which rightly doesn't have permissions
to anything.

Access should still open (just not your mdb). Go to Tools, Security, User
Accounts and click on the change password tab. You should see 'Admin' as
the user. Set a password for this user.

Close Access and try your shortcut again, this time supplying your
username/password. 

-- 
Joan Wild
Microsoft Access MVP
Robert Ponce wrote:
> This is the part that confuses me, it no longer even asks who I am.
> I dont get the login in prompt anymore.  Once I click on the short
> cut Access opens and I immediately get the message that I dont have
> the permission to get to that object.  Somehow it thinks I am not who
> I am without even asking me for the username and password.  So I am
> not sure what or where to troubleshoot next. Ideas?
>
> "Joan Wild" wrote:
>
>> OK, so it's the right workgroup.  Are you certain you are entering
>> the correct username and password?  The password is case sensitive;
>> also don't confuse the PID for a password - They are not the same.
>>
>> --
>> Joan Wild
>> Microsoft Access MVP
>>
>> Robert Ponce wrote:
>>> Yes the link I am talking about is the shortcut created by the
>>> wizard.  I looked at the target path and its just as you decribe, so
>>> nothing there looks funny or out of place.  I have the one step
>>> Security Wizard Report, but not sure if thats of any help for this
>>> problem.  Any other suggestions where to look at?
>>>
>>> "Joan Wild" wrote:
>>>
>>>> Robert Ponce wrote:
>>>>> Some how when working on my database security I managed to lose
>>>>> permission to admin on it.  Im working on an Access 2003 file and
>>>>> had everything going well;  I got a prompt asking for my name and
>>>>> password before, now when I click the link it says that I dont
>>>>> have the neccessary permision to open the object,
>>>>
>>>> Does 'click the link' refer to a desktop shortcut?  Are you sure
>>>> it's the same one that you used before?  The target of the shortcut
>>>> will have "path to msaccess.exe" "path to mdb" /wrkgrp "path to
>>>> mdw" where the mdw is the one that was used to secure the database
>>>> with.
>>>>
>>>> You are getting the error because you are not using the correct
>>>> workgroup file.  If you are just double clicking on the mdb in
>>>> Windows Explorer, you would be using the standard system.mdw.  Use
>>>> the desktop shortcut that the wizard created for you.
>>>>
>>>> --
>>>> Joan Wild
>>>> Microsoft Access MVP
-- 
Joan Wild
Microsoft Access MVP
Loading