How set password for ms access database

  • Thread starter Thread starter jaffar
  • Start date Start date
J

jaffar

hi all,

how can i set password for a database,can u give me steps for that ,
i tried , i click on the tool menu and select the security sub menu in that
i select set database password, then i get a window type password , verify,
i enter in that and click on the ok but i gives an error that u need to have
database open for exculusively use to set or unset the database password,

how can i set the pass word,,


as well as how can recover the password if i forget the password,,


with regards,

jaffar
 
jaffar said:
hi all,

how can i set password for a database,can u give me steps for
that , i tried , i click on the tool menu and select the security sub
menu in that i select set database password, then i get a window
type password , verify, i enter in that and click on the ok but i
gives an error that u need to have database open for exculusively use
to set or unset the database password,
Click to expand...

You need to start by opining the database exclusively. To do that use
the usual File-Open menu then find and choose the file you want to open.
NOW click on the little arrow to the right of the "Open" button at the
bottom of the file finder. It will show a list including "Exclusive" click
on that and the file will be open exclusively.

Some things can not be done to a database unless you have it set to
exclusive. Exclusive means only one person can open it at a time and you
can not open a database exclusively if someone else already has it open.

Check back if you have any problems.
 
I'll answer the second question first: For all practial purposes, you can't.
If you think that you will lose the password, do NOT password protect the
database. There are some companies who claim to be able to break into a
secured database; however, it isn't cheap or 100% effective. Where I work we
give our boss a list of all database and vital OS passwords. He puts it in a
safe that only he and his boss knows the combination. Therefore three people
know the passwords to any of our databases. We change passwords at least
every 90 days so it is easy to forget.

For your first question, you need to open the database exclusively. Get
everyone else out of it. Open Access. Use the File, Open dialog and select
your database. Go down to the Open button in the dialog box and hit the drop
down. Select Open Exclusive.
 
Jerry said:
I'll answer the second question first: For all practial purposes, you
can't. If you think that you will lose the password, do NOT password
protect the database. There are some companies who claim to be able
to break into a secured database; however, it isn't cheap or 100%
effective. Where I work we give our boss a list of all database and
vital OS passwords. He puts it in a safe that only he and his boss
knows the combination. Therefore three people know the passwords to
any of our databases. We change passwords at least every 90 days so
it is easy to forget.

For your first question, you need to open the database exclusively.
Get everyone else out of it. Open Access. Use the File, Open dialog
and select your database. Go down to the Open button in the dialog
box and hit the drop down. Select Open Exclusive.
Click to expand...

Thanks for covering that second question, I forgot to and it is maybe
more important than the first.
 
Back
Top