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

I have a completely secured database and I want to completely unsecure it

P: n/a
MLH
Is there a quick way to do it?

I'm logged in as the superuser
and owner of database and all
database objects. I would like
to export it to a completely un-
secured application.

Do I have to go through all
objects and security measures
one-by-one the slow and pain-
ful way?
Nov 13 '05 #1
Share this Question
Share on Google+
5 Replies


P: n/a
Presumably do the opposite of what securing a database does.

Move user Admin back into Admins, with a blank password and give the Admins
group rights to everything. You can multiselect objects you know, shift
click to select All tables, or all forms or whatever. Shouldn't take that
long.

Or if you import into your new user when logged on as the default
Admin/blank password/full rights doesn't that do it all?

Mike


"MLH" <CR**@NorthState.net> wrote in message
news:4f********************************@4ax.com...
Is there a quick way to do it?

I'm logged in as the superuser
and owner of database and all
database objects. I would like
to export it to a completely un-
secured application.

Do I have to go through all
objects and security measures
one-by-one the slow and pain-
ful way?

Nov 13 '05 #2

P: n/a
"MLH" <CR**@NorthState.net> wrote in message
news:4f********************************@4ax.com...
Is there a quick way to do it?

I'm logged in as the superuser
and owner of database and all
database objects. I would like
to export it to a completely un-
secured application.

Do I have to go through all
objects and security measures
one-by-one the slow and pain-
ful way?


Give full permissions on all objects back to the Users Group (the object
listbox is multi select, so you don't have to do it one by one).

Then rejoin the system.mdw, open Access and create a new database and import
all the objects from you secure mdb.
--
Joan Wild
Microsoft Access MVP
Nov 13 '05 #3

P: n/a
MLH
Both seem doable to me.
Guess I'll try Joan's suggestion,
then your's, Mike. Ladies first.
Nov 13 '05 #4

P: n/a
"MLH" <CR**@NorthState.net> wrote in message
news:2k********************************@4ax.com...
Both seem doable to me.
Guess I'll try Joan's suggestion,
then your's, Mike. Ladies first.


And considerably more experience too, I suspect <g>
Nov 13 '05 #5

P: n/a
MLH
I don't know about you, but I can guarantee a lot more than I have.
xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx

And considerably more experience too, I suspect <g>


Nov 13 '05 #6

This discussion thread is closed

Replies have been disabled for this discussion.