Password protection of access forms and objects

[Lee_J]

How do you Password protect access forms and objects?

 

[Roger Carlson]

Read the Security FAQ -- all of it.
http://support.microsoft.com/kb/207793/en-us

--
--Roger Carlson
MS Access MVP
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L

 

[BruceM]

Links to more information here:
http://www.geocities.com/jacksonmacd/

 

[Lee_J]

The security FAQs you refer to assume "Security Wizard". This is an Access
2007 database. There is no Security Wizard. How do you implement user level
security in 2007?

 

[Douglas J. Steele]

You don't. They've removed user level security from 2007 (assuming you're
using the new accdb format)

 

[Larry Linson]

The security FAQs you refer to assume "Security Wizard".

Why would you assume that? If you, indeed clicked through, read the KB
article and downloaded the Security FAQ... 39 pages with no 'filler
material', it should be crystal clear that Roger was not talking about the
"Security Wizard".

This is an Access 2007 database. There is no Security Wizard.
How do you implement user level security in 2007?

You can, if you choose, create an MDB with Access 2007 and use the "old
way", but as Doug pointed out, User and Group Level Security is not
supported in the new ACCDB. If you use ACCDB, it appears that Microsoft
expects you will use either SharePoint or a server DB such as Microsoft SQL
Server to store your data, rely on SharePoint's or the server's security to
secure your data, and compile to protect your code...

User and Group Level Security was, indeed, fallible and breakable, but it
did provide some useful levels of control in the application which, I
assume, if you want in an ACCDB, you will have to create yourself.

Larry Linson
Microsoft Access MVP