removing all security

[Guest]

At my bosses request, I was experimenting with security and user group
permissions. I made a local copy of one of our access databases onto my local
machine so I wouldn't mess anything up, then stepped through the user level
security wizard. Much to my horror, my security settings were applied to
every database on our network. I need to remove it all completely. Help!

Thanks,
spence

 

[Rick Brandt]

At my bosses request, I was experimenting with security and user group
permissions. I made a local copy of one of our access databases onto
my local machine so I wouldn't mess anything up, then stepped through
the user level security wizard. Much to my horror, my security
settings were applied to every database on our network. I need to
remove it all completely. Help!

Thanks,
spence

The wizard created a workgroup file with a password on the Admn user and made
that workgroup your default. All you have to do is use the Workgroup
Administrator utility to change your default back to System.mdw and the
prompting will go away.

 

[TC]

Access security is very difficult to understand initially. Believe me,
you have little hope of getting a handle on it, just by
experimentation. I recommend you obtain & read the Access Security FAQ,
often referenced in this newsgroup.

HTH,
TC