Password protect a DB

C

Chrisso

Hi All

Is there any easy way to put a password on a MS Access DB ala Excel?

I like the way in Excel you can just specify an open and a modifiy
password without worrying about groups and ids and all that.

Is such a clean simple solution possible for Access?

Thanks in advance for any suggestions,

Chrisso
 
6

'69 Camaro

Hi, Chrisso.
Is such a clean simple solution possible for Access?
Click to expand...

Yes. However, a database password is not very secure. You must first open
the database file exclusively, select the Tools -> Security -> Set Database
Password menu and type your new password, type it again to verify it, then
press the "OK" button to set it. The next time anyone opens the database
file, they will be prompted for the database password.

A better way to secure the database is to implement User-Level Security, but
that's much more complex.

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
Blogs: www.DataDevilDog.BlogSpot.com, www.DatabaseTips.BlogSpot.com
http://www.Access.QBuilt.com/html/expert_contributors2.html for contact
info.
 
Top