Chris,
TY so very much, such a simple fix to a confusing problems, Most, most
appreciated, My boss now thinks the sun shines out my Bottom

)
"Chris O'C via AccessMonster.com" wrote:
> Someone pulled a prank by removing the Admin user's password in the secure
> workgroup. Replace that password and everyone joined to that workgroup will
> be prompted for user name and password when opening a database.
>
> A common practice is to name the secure workgroup file something other than
> System.mdw so that there's no confusion between it and the default workgroup
> file. It's also easier to have everyone join the default workgroup and only
> use shortcuts that use the secure workgroup for the secure databases, so that
> the users aren't prompted every time they open a database, even the unsecured
> ones.
>
> Chris
> Microsoft MVP