Discussion Locked

Password problems with Access 2000

0 helpful
6 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

The problem we are having is with MS Access 2000.

Some of our students here are setting a password within Access.

At the User and Group accounts options with tools,security.

Once this is set , the next person to use Access is prevented fromusing Access.

What can we do?

We have tried reloading Access but joy.

The only way to solve it is to re-ghost the pc.

Zak Malek
Network Manager
ADT College
(London)
England

6 replies

by maxwell edison

Access Key is a program to recover passwords for MS Access databases.

Features:
All versions of MS Access are supported (including Access 2002)

State of the art password recovery engine - all passwords are recovered instantly
Recoversdatabase passwords

Recovers user-level security accounts and passwords

Multilingual passwords are supported

Full install/uninstall support

See this link for a free demo version:

http://www.lostpassword.com/access.htm

(REMOVE SPACES from the pasted URL.)

Maxwell

by c1980

There are 2 types of passwords: one that is set on the MDB file it self and one that is used for the person signing on. The one set on the MDB it self does not prevent someone else from using Access - only the MDB in question. You can easily crackthis password if the MDB is not encrypted.

If the password in question is for a user account, then make a back-up copy of the System.Mdw file which hasn't had any accounts, permissions or passwords set except the ones you specify, and put a password yourself on the admin account. When the kids play with the passwords and you want to put things back to normal, just delete the System.Mdw and restore it with your back-up copy. This process could be automated on a daily, or whatever, basis. Again, the only problem would be for permissions set for a certain Mdb.

One other thing you could do is set the password and permissions yourself for the Admin account, revoke admin permissions for the User account (admin rights), set up user accounts for each of the kids under a seperate group account with-out admin rights, and allow them on to sign-on with this account only, then the kids cannot hurt anything except their own account. Doing this and creating a back-up will solve alot of trouble. When the person leaves the class for good, just recopy the System.mdw to his/her PC or delete the user account.

This discussion is closed to new replies.