Userid & password system

[Herb Wexler]

I want to setup a security system that asks for a userid & password when the
application starts. If accepted it reads a record from the user table and
gets the users initials that can then be used to mark each record the user
adds or modifies.

Is this functionality built into Access 2007? I'm new to Access but have
worked with other db systems where this was a 3rd party addon for $19.95. It
had other security features such as required password strength and usage
tracking. But that is unimportant for my current project.

 

[Arvin Meyer [MVP]]

No, it's not built in, but fairly easily coded. I use a system which doesn't
require a login, but instead grabs the login from the Windows login, and
uses that:

http://www.mvps.org/access/api/api0008.htm

 

[Herb Wexler]

The other system I used had a feature that controlled the access to each form
or report for each user. I'm surprised I can't find something like that for
Access.
--
Herb Wexler MBA
www.PreventingMediocrity.com
Norwalk, CT 06854

 

[Arvin Meyer [MVP]]

The method of login does not preclude how you are using security. In Access
2003 and earlier, there is a built-in security system that does control
access to everything, and is much better than any "home-grown" system. Keep
in mind, however, that Access/JET is a file-server database engine, and as
such cannot provide the security level that a server based system does.
Here's the info on the built-in User Level Security:

Security FAQ
http://support.microsoft.com/download/support/mslfiles/SECFAQ.EXE

Lynn Trapp's summarization:
http://www.ltcomputerdesigns.com/The10Steps.htm

KB articles:
http://support.microsoft.com/default.aspx?scid=KB;en-us;q165009
http://download.microsoft.com/download/access97/faq1/1/win98/en-us/secfaq.exe
http://support.microsoft.com/default.aspx?kbid=325261

Joan Wild's articles:
http://www.jmwild.com/security02.htm
http://www.jmwild.com/security97.htm
http://www.jmwild.com/SecureNoLogin.htm
http://www.jmwild.com/Unsecure.htm
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com