"Joan Wild" wrote:

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