Creating a Login in Access

[Guest]

I am utilizing Microsoft Office 2000 ACCESS to try and design a help tool. I
have everything else completed except the way the Users will login Then of
course bringing it all together as one ACCESS Program.
Currently the Sign-on form I have only works 1 way. Whether or not you get
the UserName and the Password correct I allows you to proceed. Can anyone
assist me with telling me how I can get the Login to allow access and show
the form I want when everything is correct, and if anything is incorrect show
the proper failure form?

 

[Guest]

Hi,

could you please provide more details, e.g. using MS Access built in
security with users and groups or using selfdefined security etc.

 

[Guest]

There are at least two approaches to controlling permissions based on user
identity.

First, you can roll your own. For example, create a table to track user
identities. Associate a table of permissions for your solution with the
identities. Then, make users identify themselves when they login. Finally,
check the permission for an identity before permitting various protected
actions.

Second, you can use the built-in user-level security for Access. This has
been around since the beginning of access. This approach relies on a system
workgroup file (.mdw) that tracks users, groups, and permissions. The system
workgroup file interacts with your database file (.mdb). Access has a long
list of permissions for various objects. These permissions vary depending on
the type of object. You can manage the assignment of permissions to users
and groups either through a graphical UI or programmatically.

Over the years, I noticed that many power users and developers have a
limited understanding of user-level security. This can lead to the improper
setup of user-level security. My book, Programming Microsoft Office Access
2003, includes coverage of both manual and programmatic means of managing
user-level security. Because of the stability of user-level security across
multiple versions of Access, the content in the book applies to Access 2000.

Rick Dobson
www.programmingmsaccess.com

 

[Guest]

Oliver & Rick,

Thank you for your replies, (Oliver) I wish I knew how to explain what I am
looking for, however I am doing this the hard knocks method. In other words I
have no programing knowledge at all. I am trying to learn by jumping in and
trying to learn while reading.
(Rick) Thank you for the input, my situation is that I have a table and form
created but cannot get it to function properly. Any ideas? Recommendations?
Thanks
Phil