I have two databases that I am currently working on. The one database needed
password security protection. I enabled the protection for the one database.
Saved and closed the file and went home for the weekend. I come back monday
morning and open the database that was supposed to be without the protection
and apparently what I created from the database WITH the protection carried
over to the one WITHOUT. I am now in a frenzy because I can't get the
password off or even the security icon that says login....... off of the
database that is supposed to be without the protection. HOW can I get this
removed without effecting the database that is supposed to be with. They do
not piggy back off of one another or have similar application names.

HELP!

When you secured the first one, during the process Access made your secure
mdw the default one to use for every session.

Access always uses a mdw file.  Out of the box it uses system.mdw and
silently logs you in as 'Admin'.  When you secured, you created a new mdw
file (and Access changed your default to this file).

The mdw is tied to the session of Access, not to a database.  Open Access,
and go to Tools, Security, Workgroup Administrator, and rejoin system.mdw
(you might want to search for *.mdw first to get its location).

The above assumes that you are using version 2002 or 2003 - post back if a
different version.  It also assumes that you actually *did* create a new mdw
and not modify the standard system.mdw.If you did not create a new mdw, and
you're using 2002/2003, just rename system.mdw to system1.mdw.  When you
start Access, it'll create a new system.mdw file for you.

References for security:
Security FAQ
http://support.microsoft.com/?id=207793

Security Whitepaper
http://support.microsoft.com/?id=148555


news:8d07d3592a73a@uwe...
Show quoteHide quote

Oh Thank You Joan!!

I still have one minor issue....

I'm trying to make sure the database with the security remains mutually
exclusive and away from corrupting or taking over any other database. I
cleared out and joined with system1.mdw as my default setting. The database
with the security setting is on another drive and also on a server. When I
try to login to the database now after changing to system1.mdw an error
message appears and says I do not have the neccessary permission to access
the file (this is for the database with the 'security login') that I can't
get into.

Thanks for your help!

I'm not sure that you want to change to system1.mdw - you want your default
set to the system.mdw that ships with Access (it should be called
system.mdw)

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.

Create a new shortcut to msaccess.exe.  Then right-click this shortcut and
modify the 'target' line to have the following in it:
"path to msaccess.exe" "path to secure mdb" /wrkgrp "path to secure mdw"
modifying the above to reflect the locations of these files.

Use the shortcut for your secure mdb; the /wrkgrp switch will override your
default mdw and use the mdw specified in "path to secure mdw".  It will do
so, only for that session of Access.  All other sessions of Access will use
your default system.mdw, and require no login.

news:8d09270b7ace8@uwe...
Show quoteHide quote

join mdw from vba code
Different passwords in Access 2007
No more double-click code access?
Allowing people to only enter data into a form
Read only message
Extra DBs created
Remove or disassociate a mdw
Compile Codes
password recovery for MS Access DB
Next Release of MS Access