Removing security from Access 2002

[Glenda]

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

 

[Rick Brandt]

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

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.

 

[Lynn Trapp]

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.

 

[Glenda]

Thank a bunch!!!

How do I restore the backup Access database?

 

[Lynn Trapp]

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.

 

[Glenda]

I want to restore the backup made during the security
wizard. Is it possible?

 

[Lynn Trapp]

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.