Re: Lost ability to login to secure database

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: nicolle (nicolle_at_discussions.microsoft.com)
Date: 11/19/04

  • Next message: '69 Camaro: "Re: SOLUTION FOUND" 
    Date: Fri, 19 Nov 2004 11:49:08 -0800

    Wow, this worked! Thanks so much.

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

  • Next message: '69 Camaro: "Re: SOLUTION FOUND"

    Relevant Pages

    • Re: Securing Back-End, Using one .mdw file on FE & BE
      ... "Joan Wild" wrote: ... You open a session of Access using your secure mdw and logging in as the ... I am using a shortcut to open the FE, ... BE using the same .mdw file from the FE. ...
      (microsoft.public.access.security)
    • Re: Lost ability to login to secure database
      ... > to login and cannot open any of my secured databases. ... I assume you know the workgroup file that was used to secure your ... 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: High security Needs, Cheep Clients, Need Help
      ... I have a new client who needs secure hosting solutions, ... I am hosting web services on the server to provide the interface with the ... MYSERVER\PUBLIC contains all my existing, non-secure, databases plus some ...
      (microsoft.public.sqlserver.security)
    • Re: set database password when converting AC00 to AC07
      ... Reading that db option only tells you what the setting is, ... If the locking file is already open when you try to ... To guarantee opening in exclusive mode use a shortcut with the /excl switch. ... Application.GetOption("Default Open Mode for Databases"). ...
      (microsoft.public.access.security)