Re: How to remove password dialog?

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

From: Kimmy (anonymous_at_discussions.microsoft.com)
Date: 09/08/04 

Date: Wed, 8 Sep 2004 09:50:21 -0700

Hi,

After cleaning Admin pw, I was able to get rid of pw
prompt. Thank you.

However, when I copy my mdb file to another machine, I
still not able to access my db from there directly (MEANS
double click mdb file), I got msg that I do not have
permission. But if I access thru a shortcut on the desktop
then it's OK. How could it happen?I did clean all user
group and Admin pw. Do I need to do something with
secured.mdw file?

Many thanks in advance. Kimmy

>-----Original Message-----
>Kimmy wrote:
>> Hi,
>>
>> I am new to Access. I tried to set security using
security
>> Wizard, I was able to set up the way I want. However, I
am
>> still in development mode, I want to deactiviate
password
>> dialog box,
>
>I suggest you create/modify your desktop shortcut to
include the
>username/password. Add the following to the existing
target
>/user "whatever" /pwd "yourpassword"
>
>> I clean user users/groups using wizard, but I
>> could not get rid of password prompt.
>
>Not advised, but you can stop the login prompt by
clearing the password for
>the Admin user.
>
>> In addition, I
>> notice that my secutity setting for this DB is also
>> applied also to the othe Access DB on my machine which
is
>> noit the way I want.
>
>You are joined by default to your secure mdw. use the
workgroup
>administrator (Tools, Security) to join the standard
system.mdw. Use your
>desktop shortcut for your secure database. It will
bypass the default
>workgroup for that session.
>
>
>--
>Joan Wild
>Microsoft Access MVP
>
>
>.
>

Relevant Pages

  • Re: how to detach an mdb from an mdw file?
    ... > I'm helping assess some enhancements needed for an Access/SQL Server ... > the mdw file for user security info. ... The mdb file doesn't, the Access session does. ... Access and is used by default (it silently logs you in as 'Admin' user). ...
    (microsoft.public.access.security)
  • Re: user icons gone from welcome screen!
    ... Well, Patrick, I tried a password cracker, and it reported that the admin ... Safe mode does no better. ... Can't get to command prompt as it wants you to log on first. ... If you use an inexpensive external USB2 drive case or drive connector, ...
    (microsoft.public.windowsxp.perform_maintain)
  • Re: how to detach an mdb from an mdw file?
    ... So I tried you suggestion to create a new MDB file and import the objects. ... I tried the build "admin" account, and also the documented admin account in ... the domain, and the MDW file is on a server on the same domain, and SQL ... Security and will read through it this weekend. ...
    (microsoft.public.access.security)
  • Re: how to detach an mdb from an mdw file?
    ... So I tried you suggestion to create a new MDB file and import the objects. ... I tried the build "admin" account, and also the documented admin account in ... the domain, and the MDW file is on a server on the same domain, and SQL ... Security and will read through it this weekend. ...
    (microsoft.public.access.security)
  • Re: how to detach an mdb from an mdw file?
    ... So I tried you suggestion to create a new MDB file and import the objects. ... I tried the build "admin" account, and also the documented admin account in ... the domain, and the MDW file is on a server on the same domain, and SQL ... Security and will read through it this weekend. ...
    (microsoft.public.access.security)