Unsecure a database

[Leslie Isaacs]

Hello All

I have a split, secured A2K mdb that I need to unsplit and
unsecure. I have started by creating a new, blank mdb,
opening this up via the workgroup information file, then
importing the queries, forms etc from the front end mdb,
and then importing the tables from the back-end mdb. So
far so good (I think?): but how to unsecure the new mdb?

Hope someone can help - I've trawled the on-line resources
but couldn't find what I needed.

Many thanks
Les.

 

[Joan Wild]

Hi Leslie,

What you've done is not the correct method.

Open your database using the secure mdw and login as the user that's a
member of the Admins group.

Give full permissions to all objects to the Users Group (don't forget the
database object).

Exit Access, and then reopen it using the standard system.mdw workgroup.

Create a new database and import all objects from your secure database.

 

[John C.]

From Section 34 of the Security FAQ

http://support.microsoft.com/support/access/content/secfaq.
asp

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
helped protect the database. 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.

 

[Leslie Isaacs]

Hello Joan
Many thanks - that worked a fine!
Les

Hi Leslie,

What you've done is not the correct method.

Open your database using the secure mdw and login as the user that's a
member of the Admins group.

Give full permissions to all objects to the Users Group (don't forget the
database object).

Exit Access, and then reopen it using the standard system.mdw workgroup.

Create a new database and import all objects from your secure database.