ASP and Microsoft Access 1

[debbierich22]

I am currently developing a website using ASP. I want to store user information (user id, password, etc.) in a database to accomplish the logon functionality as well as keeping track of user roles and a very small amount of other information not pertaining to users.

I cannot use SQL Server. I only have Microsoft Access at my disposal. I have not been able to find any examples using Access as the database rather than SQL Server. I am a beginner when it comes to ASP and I'm not sure how to proceed from here. Any examples or information about where to find an example or even how to start would be greatly appreciated.

 

[BigBadDave]

Have a look at this post :

thread215-162881 Regards

Big Dave

davidbyng@hotmail.com


** If I am wrong I am sorry, but i'm only trying to help!! **

 

[goatstudio]

You can take a look at

http://www.asp101.com

too. ------------------
Freedom is a Right

 

[BlindPete]

Or

http://www.learnasp.com

is also rich with example connections. If you are looking for a test zone try

http://www.brinkster.com

they will host 30MB for free w/o adds and support MS Access DSN or DSNless connections. Unbelievable but true.
-Pete

 

[debbierich22]

Thanks for pointing me in the right direction. I didn't find that thread Dave pointed me to because it wasn't in the ASP forum.

Dave, I do have a question. I set up your example but when I run it and click the submit button, I get the generic 404 page not found error. Is there something wrong with the database connection? I have the database saved in the same directory as the page. Any ideas what I am missing?

Thanks again.

 

[Guest_imported]

I have a database. reading n displaying info from it is no problem. I have managed to do that without any glitches. I am now trying to put an add function in it. if any1 accesses my page, they can add a message if they want to. But I can't figure out how to write the ASP side to writing to a database. Can u help me out plz

 

[SHARKY99]

rsDatabase("your_field&quot= "what you want" or Request.Form("your_txtbox&quot


rsDatabase.Update


That's it....

Have Fun...

Sharky99 >:O>

 

[sdimov]

http://www.asp101.com