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

[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?

[Mike MacSween]

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?

[Joan Wild]

"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

[MLH]

Both seem doable to me.
Guess I'll try Joan's suggestion,
then your's, Mike. Ladies first.

[Mike MacSween]

"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>

[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>