Repost: Unsecuring a db

D

Damien McBain

One of my db's is secured with the use of the mdw file. I didn't keep an
up-to-date development copy (the secured one is the copy I want to keep) -
doh.

I've made a copy of the db which is of course also secured. I've deleted all
the users except Admin and cleared the admin password but the db still won't
open without referring to the workgroup it's associated with.

I this achievable or do I have to copy all the objects into a new db?

Damo
 
R

Rick Brandt

Damien McBain said:
One of my db's is secured with the use of the mdw file. I didn't keep an
up-to-date development copy (the secured one is the copy I want to keep) -
doh.

I've made a copy of the db which is of course also secured. I've deleted all
the users except Admin and cleared the admin password but the db still won't
open without referring to the workgroup it's associated with.

I this achievable or do I have to copy all the objects into a new db?
Click to expand...

Give the default group "Users" full permissions to all objects and then
close the file. Reopen Access using a non-secure mdw and create a new
blank file. Import all objects from the old file into this new one. The
resulting file should be identical to one that was never secured in the
first place.
 
Top