ASP Forum
MS Access with ASP/ADO Login
Joshanasa | Posted 4:17pm 7. May 2009 Server Time |

Hi, I am trying to create a website login for my website. I have an MS Access database made, and a dsn for it. But I am not sure what code to use. What code would I use to connect to the database, and then what would I use to have the code check to see if the username is in the database, and if the password macthes?
bbcompent1 | Posted 6:46am 8. May 2009 Server Time |

Well for starters, you would need to specify your connection string like this:

DSN=myDsn;Uid=myUsername;Pwd=myPassword;

Once you have your DNS specified, you can refer to it.  I usually keep my connection string in a separate file and then at the top of my asp pages, I just include it.

Here is an example of creating a login system by 4guysfromrolla.com

http://www.4guysfromrolla.com/webtech/021600-1.shtml
Joshanasa | Posted 2:41pm 8. May 2009 Server Time |

Well, how do i make the ASP/ADO check to see if the username and password match and are in the database?
ArchanaMFadt | Posted 0:06am 11. May 2009 Server Time |

i am working with uploading files.
requirement is as follows
when user enters his details firstly his email will be validated if already exist he will directly upload the file
if not he has to feed all information then his folder will be created and in that folder his files will bw uploaded.
how tro do this
please can you give the source code for this....

Thanks
Archana
Joshanasa | Posted 7:52pm 11. May 2009 Server Time |

Hey, soon I will have a bunch of coding tutorias about all different types of web page programming on ym web site soon. (http://www.jacdom.com). I found some code for making an access user login databse, so soon I will post them there, so stay in touch.


Reply to Post MS Access with ASP/ADO Login



Back to Forum Page