Hi Walley,
Open your database in Exclusive mode. You can do this by opening Access 2007
by itself, without double-clicking on a .mdb or .accdb file. Click on the
Office button in the upper left corner (the round button with the logo).
Click on Open. Select your database, and use the Open dropdown at the bottom
of this dialog to choose "Open Exclusive".
After opening the database, select the "Database Tools" tab on the ribbon.
On the right-hand side of the ribbon, you should see an option that reads
"Encrypt with Password". Click on this option and enter the password of your
choice.
Why this option is not available when clicking on the Office Button,
followed by the "Access Options..." button, and then selecting the Current
Database tab is beyond me... Setting a database password certainly appears
to be an operation that *should* be listed under Current Database, but it is
not.
Tom Wickerath
Microsoft Access MVP
http://www.accessmvp.com/TWickerath/
__________________________________________