opening access database with/without password

Hi ng,

I'm running a few databases on my desktop and I want to
secure one database. To achieve this, I started the
WRKGADM and joined a workgroup, set a password etc. Now
everytime I trie to open any MSACCESS 2000 database,
access asks for username and password.


any helpful hints??

jokobe

jokobe wrote:
> Hi ng,
>
> I'm running a few databases on my desktop and I want to
> secure one database. To achieve this, I started the
> WRKGADM and joined a workgroup, set a password etc. Now
> everytime I trie to open any MSACCESS 2000 database,
> access asks for username and password.

Joining a workgroup means making it the default one to use for all sessions;
that is why you are getting the login prompt. Rejoin the standard
system.mdw that ships with Access. For your secure database, create a
desktop shortcut to launch it - it's target would look like:

"path to msaccess.exe" "path to mdb" /wrkgrp "path to mdw"

This shortcut will use your secure mdw for just that session. All other
sessions will use the system.mdw workgroup.

--
Joan Wild
Microsoft Access MVP

> any helpful hints??

Sure. You've set the password for the Admin user of your current workgroup.
You can either rejoin the default workgroup, which shouldn't have a password
set for the Admin user, or you can remove the password for the Admin user of
your current workgroup.

To remove the password for the Admin user of your current workgroup, log
into any database as the Admin user again and remove the password. Close
Access. You will not be prompted the next time you open a database.

To rejoin the default workgroup, search for the "System.mdw" file on your
hard drive. You may find more than one of these files, but the default
workgroup file should be in your Windows System directory or in a directory
in your profile, depending upon your OS. Use WRKGADM.Exe again to join that
workgroup. You will not be prompted the next time you open a database,
unless the Admin user for this workgroup also has a password set, which you
can remove.

HTH.

Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.

(Please remove ZERO_SPAM from my reply E-mail address, so that a message
will be forwarded to me.)


"jokobe" <anonymous@discussions.microsoft.com> wrote in message
news:14d601c499a2$693d1920$a401280a@phx.gbl...
> Hi ng,
>
> I'm running a few databases on my desktop and I want to
> secure one database. To achieve this, I started the
> WRKGADM and joined a workgroup, set a password etc. Now
> everytime I trie to open any MSACCESS 2000 database,
> access asks for username and password.
>
>
> any helpful hints??
>
> jokobe