Re: Lost ability to login to secure database

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

From: Joan Wild (jwild_at_nospamtyenet.com)
Date: 11/17/04 

Date: Wed, 17 Nov 2004 10:57:09 -0500

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: Lost ability to login to secure database
    ... "Joan Wild" wrote: ... >> to login and cannot open any of my secured databases. ... >> secure Access databases. ... Create a desktop shortcut to open them. ...
    (microsoft.public.access.security)
  • Re: Removing Security
    ... Rejoin the default workgroup and use a shortcut for each ... Any time you need to open a secure db, you use the shortcut, which ... How do I turn this off for all databases. ... without a login requirement. ...
    (microsoft.public.access.security)
  • Re: Remove/Add BUILTINAdministrators 2000 sp4
    ... any of the databases. ... exist anywhere in sql server either. ... detected that this login has permissions....etc this login ... be mapped to dbo. ...
    (microsoft.public.sqlserver.security)
  • Re: Remove/Add BUILTINAdministrators 2000 sp4
    ... detected that this login has permissions....etc this login ... be mapped to dbo. ... sysusers in the user databases and syslogins in master. ... I have seen a windows group referred to as a LOGIN for sql server in the ...
    (microsoft.public.sqlserver.security)
  • Re: Two DB Owners
    ... full permissions in all databases. ... Note that the user will still be known as the 'dbo' user as long as the ... I need to add the login 'BUILTIN\Administrators' ... > 'DYNGRP' and 'BFGROUP' roles of the Dynamics and DAVCatalog databases. ...
    (microsoft.public.sqlserver.security)