Rob said:
I just tried to set up user groups for a database. However, now whenever I
open any access database I am receiving the same Username/password pop-up.
How do I remove this and set the user groups for a specific database rather
then any access database that I open?
Whether you are prompted for aserName and password is dictated by the
workgroup file being used and that is NOT controlled by which file you are
opening since the workgroup is loaded before the application file.
When you created a new workgroup file for your secure app Access
(unhelpfully) made that workgroup your default. You just need to use the
Workgroup Administrator to change your default workgroup back to System.mdw.
Then you can use a custom shortcut for your secured file that specifies a
different mdw file as a command line parameter. The syntax is roughly...
"path to MSAccess.exe" "path to mdb" /wrkgrp "path to mdw"
