Password protect a DB

[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

 

[Joseph Meehan]

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

I don't know of all versions are the same, but check out the top line
menu [Tools] - [Security].

I suggest you also try reading
http://support.microsoft.com/default.aspx?scid=kb;[LN];207793

Access User Level Security is a great feature, but it is, by nature a
complex product with a very steep learning curve. Properly used it offers
very safe versatile protection and control. However a simple mistake can
easily lock you out of your database, which might require the paid services
of a professional to help you get back in.

Practice on some copies to make sure you know what you are doing.

 

['69 Camaro]

Hi, Chrisso.

Is such a clean simple solution possible for Access?

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.