Removing security from Access 2002

  • Thread starter Thread starter Glenda
  • Start date Start date
G

Glenda

I have a database application that I scecured.
Now, I want to remove all security, users and all. How
doi I do that?
 
Glenda said:
I have a database application that I scecured.
Now, I want to remove all security, users and all. How
doi I do that?
Click to expand...

Log on as an administrator and give full permissions to all objects to the
default Users group.

Close Access and then reopen using a non-secure workgroup file. Create a
new blank file and then import all objects from your original file.

The resulting file will be the same as one where security was never
applied.
 
1. Login to the database as a member of the Admins group.
2. Add the Admin user back into the Admins group.
3. Give the Users Group full permissions to all objects in the database.
4. Have all your users join the system.mdw file that shipped with access.
5. Login as the Admin user and clear the login password.
 
That depends on how you did the backup. If you used some kind of backup
system, then you will need to us that system's restore functions. If you
simply saved a copy of the database to another folder, then just copy it
back to the original location.
 
Ah, look in the folder where your database is. There should be a file with
the same name but a .bak extension. Change the extension to .mdb -- of
course, you will need to change the name of the secured .mdb file first.
 
Back
Top