Starting new on protecting an area for individuals to go to

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a form and a cmd button on this form that when clicked will bring up a
form that asks for a user name (same as last name) and a password to be
entered. I would like the information input on this form in these two areas
to match information in a table and if both match then it would open a
switchboard form for further data information.
I have added a field called password in the table and made it a text field.
I have made a form called "security" that I need to put the username and
password entries in and this form would then check against the entries in the
table. If all is okay then it would open a form called 'members' and if all
is not well then an information box would come up telling the person sorry
you can not enter.
What is best way to accomplish for maximum security.
 
Why not just implement Access user and group-level security.

Refer to the Security FAQ for information about how to do it:
http://support.microsoft.com/?scid=http://support.microsoft.com/support/access/content/secfaq.asp

You can download the Access97 SECFAQ from here:
http://download.microsoft.com/download/access97/faq1/1/win98/en-us/secfaq.exe

Although it's for Access97, you can still use it for later versions.

Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia

Microsoft Access 2003 VBA Programmer's Reference
http://www.wiley.com/WileyCDA/WileyTitle/productCd-0764559036.html
 
Tad nervous about getting into the user and group areas as locked myself out
of my computer mucking about with this and I do not want to create the same
problem in the database. I will try but how can I test it as I am on a
standalone environment and I am the only user that I want on this machine?
 
The FAQ tells all.

Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia
---------------------------
 
If I were creating a database that I wanted secure from the get go the FAQ is
very helpful.
The object here however is to branch off of an open to all database into an
area for members only. Thus what I am attemting to do is create a member
only area within a database.
Is there not a simpler way of getting the program to say "hey you clicked
this button and now I want you to tell me who you are?" If it (the program)
does not like the answer given by the user it pops up a message saying "Go
Away"
 
Using user/group-level security is still the way to go. Once the user has
logged on, the system knows who they are. Then all you need do is set up
permissions (as described by the FAQ) to each object (form, report, macro,
etc) based on group membership.

Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia

Microsoft Access 2003 VBA Programmer's Reference
http://www.wiley.com/WileyCDA/WileyTitle/productCd-0764559036.html
 
Back
Top