By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
457,906 Members | 1,771 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 457,906 IT Pros & Developers. It's quick & easy.

Removing MDW security

P: n/a
If a person has a MDB secured with user-level security that uses an MDW,
what steps does one take to fully remove the user-level security.
Oct 16 '08 #1
Share this Question
Share on Google+
3 Replies


P: n/a
On Wed, 15 Oct 2008 20:02:34 -0700, Salad <oi*@vinegar.comwrote:

It's in the Security FAQ available on microsoft.com:

34. How can I "de-secure" a database?
You must have Administer permissions and/or be a member of the Admins
group in the workgroup information file that the database was secured
with. Grant full permissions to the Users group and the Admin user
account. Put the Admin user back in the Admins group and remove the
password from the Admin user. You will not be prompted for a logon ID
and password once the password is removed from the Admin user.
Optionally, you can also run the Security Wizard again to transfer
ownership of all objects back to the Admin user, but the wizard will
also remove permissions from the Users group, which you may not want.

-Tom.

>If a person has a MDB secured with user-level security that uses an MDW,
what steps does one take to fully remove the user-level security.
Oct 16 '08 #2

P: n/a
"Tom van Stiphout" <to*************@cox.netwrote in message
news:oa********************************@4ax.com...
On Wed, 15 Oct 2008 20:02:34 -0700, Salad <oi*@vinegar.comwrote:

Optionally, you can also run the Security Wizard again to transfer
ownership of all objects back to the Admin user, but the wizard will
also remove permissions from the Users group, which you may not want.
And if you'd rather not run the wizard (and who would want to? ;) ) then, as
a final step, import all objects into a new blank mdb file.

Keith.
www.keithwilby.co.uk

Oct 16 '08 #3

P: n/a
Keith Wilby wrote:
"Tom van Stiphout" <to*************@cox.netwrote in message
news:oa********************************@4ax.com...
>On Wed, 15 Oct 2008 20:02:34 -0700, Salad <oi*@vinegar.comwrote:

Optionally, you can also run the Security Wizard again to transfer
ownership of all objects back to the Admin user, but the wizard will
also remove permissions from the Users group, which you may not want.

And if you'd rather not run the wizard (and who would want to? ;) )
then, as a final step, import all objects into a new blank mdb file.

Keith.
www.keithwilby.co.uk
Thank, Keith and Tom
Oct 16 '08 #4

This discussion thread is closed

Replies have been disabled for this discussion.