Security...

[Chuck]

I attempted to place a security prompt on an access dbase
yesterday via the user and workgroup wizard, and now
whenever I attempt to open another one, (pre-existing or
even create a new one), I am promted for a password. How
would I go about removing this all together?

 

[Lynn Trapp]

Chuck,
If you want to keep the secuity on the one database then you need to do the
following things:

1. Use the Workgroup Administrator to join the default security file --
system.mdw (search your computer for this file).
2. Create a shortcut for your secure database that points to the secure
..mdw file. The general syntax for the shortcut is:

"FullPathToMSAccess.exe" "FullPathToDatabase.mdb" /wrkgrp
"FullPathToWorkgroupFile.mdw"