remove decurity from a database

[Alex]

Hi I need to remove the security from a database. i have all te user names
and passwords, but how do i tell which one had the admin rights, which
presumably I need to know in order to reset all the rights etc

thanks

Alex

 

[Joan Wild]

Hi I need to remove the security from a database. i have all te user names
and passwords, but how do i tell which one had the admin rights, which
presumably I need to know in order to reset all the rights etc

To unsecure the database, you need to login as a user that's a member of the
Admins group.

Then give full permissions to everything (including the database object) to
the Users Group.

Start Access while joined to the standard system.mdw workgroup. Create a
new database and import all objects from your secure database.

To find out which user is a member of the Admins Group, you should be able
to login as each user and go into Tools Security Permissions, and see who
owns the objects (this will only be successful if you've signed in as the
right user).