Re: Lost ability to login to secure database

Tech-Archive recommends: Fix windows errors by optimizing your registry

Hi Joan. I also fubarred my secure database.
Here is what I did, and what I have done so far.

First I moved the folder my database was in.
Then I deleted the shortcut on my desktop
Then I emptied my recycle bin (gone for good!)
Then I tried to open the database .mdw file straight from the folder it is
stored in.
*panic*
Then started fooling around with the security settings and passwords etc etc.

I arrived at a point where I was no longer even being asked for my user/pwd.
and almost started to cry.
----------------------------------------------
Then came to this post, fixed the admin with no pwd problem, and now I'm
back to being asked for my password again, but I get the error " you don't
have the neccessary permissions blah blah blah".

From your posts above, I think it's a 'workgroup' problem, i deleted my
original shortcut that the wizard made for me. Am I screwed for good?
Can I make a short cut?

I'm frantic.
--
We sell mannequins to retailers.
They smile, laugh, and kiss!
www.bigsmile.ca


"Joan Wild" wrote:

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.


You are getting that message because you are not using the correct workgroup
file to open the mdb.

I assume you know the workgroup (mdw) file that was used to secure your
databases. Create a desktop shortcut to open them. Put the following in
the target of the shortcut:

"path to msaccess.exe" "path to secure.mdb" /wrkgrp "path to secure.mdw"
Launch your mdb via this shortcut.

If your login info is not recognized, check that your capslock key is set
correctly as the password is case sensitive. Also, your password may be
blank. Try logging in with your username and blank password.

--
Joan Wild
Microsoft Access MVP



.

Relevant Pages

  • Re: I DONT WANT ANY PASSWORD PROTECTION
    ... Once you've set your default to the one that ships with Access (and therefore doesn't ask for a login), you'd then use a desktop shortcut to open your secure mdb. ... I'm trying to make sure the database with the security remains mutually ...
    (microsoft.public.access.security)
  • Re: User access on a company intranet
    ... I did as you said and created a shortcut with the path you gave me and it ... I have built into my database should I disable this? ... When you want to implement security, you create a new mdw file, and follow ... to open the secure mdb is by using the mdw you created. ...
    (microsoft.public.access.security)
  • RE: security wizard cannot be run
    ... I was fine with that until 'use your desktop shortcut'. ... for the Admin user. ... I tried to log on as Admin but couldn't get in to the database, ... Security permissions are stored in the mdb file. ...
    (microsoft.public.access.security)
  • Re: IUser Updating Tables
    ... I'm grabbing a users active directory login then letting them view ... certain applications base on that. ... same general folder that I grab the login with. ... Will I have problems updating a database with any ...
    (microsoft.public.inetserver.asp.db)
  • Re: security wizard cannot be run
    ... You need to open your database using your secured mdw (i.e. the desktop ... Open Access (not via the shortcut). ... Create a new mdb and import everything from your 'secure' mdb. ... Once the database opens, the ...
    (microsoft.public.access.security)