Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / General 2 / March 2007

Tip: Looking for answers? Try searching our database.

Password protect a DB

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Chrisso - 30 Mar 2007 12:25 GMT
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 - 30 Mar 2007 12:44 GMT
> Hi All
>
[quoted text clipped - 8 lines]
>
> 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.

Signature

Joseph Meehan

Dia 's Muire duit

'69 Camaro - 30 Mar 2007 19:35 GMT
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.

> Hi All
>
[quoted text clipped - 8 lines]
>
> Chrisso
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.