BleepingComputer.com: Make login and check with user name/pass in MS Access?

Jump to content

Page 1 of 1
  • You cannot start a new topic
  • You cannot reply to this topic

Make login and check with user name/pass in MS Access?

#1 User is offline   burnface 

  • New Member
  • Pip
  • Find Topics
  • Group: Members
  • Posts: 14
  • Joined: 26-April 09

Posted 27 April 2009 - 03:31 PM

School project: Create website with ColdFusion and dreamweaver with a login that pulls info from database made in ms access.

After i make the database with the usernames and passwords in it, how do i make the web page actually check with the database and verify that the username and password are correct?

#2 User is offline   groovicus 

  • Hail Groovicus!
  • PipPipPipPipPipPip
  • Find Topics
  • Group: Moderator
  • Posts: 9,605
  • Joined: 05-June 04
  • Gender:Male
  • Location:Centerville, SD

Posted 27 April 2009 - 04:34 PM

What do you have so far?
"Take the risk of thinking for yourself, much more happiness, truth, beauty, and wisdom will come to you that way" - Christopher Hitchens

#3 User is offline   burnface 

  • New Member
  • Pip
  • Find Topics
  • Group: Members
  • Posts: 14
  • Joined: 26-April 09

Posted 27 April 2009 - 11:20 PM

Well i have the login page and everything, but i just can't figure out how to make it check with my access database. I guess i'm not really even sure how to ask for help without uploading the files i have or something..

#4 User is offline   groovicus 

  • Hail Groovicus!
  • PipPipPipPipPipPip
  • Find Topics
  • Group: Moderator
  • Posts: 9,605
  • Joined: 05-June 04
  • Gender:Male
  • Location:Centerville, SD

Posted 27 April 2009 - 11:40 PM

Have you figured out yet that the password checking needs to be done on the servr side, and it is not the HTML that does it? Here is the flow:

1) User goes to the website. Most of the time, registered users have a cookie set on their systems, so the javascript checks for a cookie. If there is a cookie, they are presented with a login form. If not, theyr are presented with a registration form.
2) Assuming for now that you just want to have people log in every time, then the user is presented with a login page.
3) The user fills in their info, hits submit, and the information is sent to the server.
4) On the server, some script gets the information. The script queries the database. If there is a user equal to the user in the form, then it compares the password from the database with the password the user submitted.
5) If the password and username match those found in the database, the user gets to see one page. If they are not the same, the user gets another page.

************************

I don't know anything about ColdFusion, but I don't need to. The process is the same whether one is using .Asp, CGI scripts, Java, or PHP. Your form will call a .cfm file on the server. The .cfm file does the comparison and returns the HTML page.

Does that help at all? I have a post here that explains the process using PHP. It is the same process, just with a different language.
"Take the risk of thinking for yourself, much more happiness, truth, beauty, and wisdom will come to you that way" - Christopher Hitchens

#5 User is offline   TheStalker 

  • Member
  • PipPip
  • Find Topics
  • Group: Members
  • Posts: 55
  • Joined: 16-September 08

Posted 13 May 2009 - 10:37 AM

As above really only thing i can really add is that i guess you would need to use some sort of ODBC function to connect to access, but this is only a guess i dont have a clue about ColdFusion.

Share this topic:


Page 1 of 1
  • You cannot start a new topic
  • You cannot reply to this topic

1 User(s) are reading this topic
0 members, 1 guests, 0 anonymous users