How set password for ms access database

[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

 

[Jerry Whittle]

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.