"Nicolle" wrote:

> I am having the same problem that was described in this discussion. However,
> the solution is not working for me. I have lost the ability to login and
> cannot open any of my secured databases.
>
> I am the administrator, creator and as of now sole user of a set of secure
> Access databases. When I try to open a database I receive a message saying
> that I don't have the necessary permission.  Every once and while the login
> box does pop up (I can't figutre out why) but my login infor is not
> recognized. Please help! Thank you.
> 
>
> "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
> >
> >
> >