How do I use MS Access databases for web passwords?

Answer 1

I agree that storing passwords and user data into an access database is not the most recommended method. It's not very secure and is rather slow. It also has a low limit of simultaneous user connections allowed...
But if you must know, here's how to do it using ASP (on a Windows IIS server):

Set objConn = CreateObject("ADODB.Connection")
objConn.Open("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("/") & "\..\databases\yourdbname.mdb")

This connection string works on ASP using VBscript. You'll have to make sure you set the relative path to your database file correctly so the script can find it.
Good luck!

Looks like the code gets cut off in parts by yahoo answers. If you need more help, ping me on 360.
-J

Answer 2

My suggestion is not to use MS Access to store web passwords on your local system. It is relatively weak not robust and the global DB users are the best testimony for not using it. Instead use something like MySQL(open source)(platform independent).

Remember u r storing password related information!! Don't compromise on it!!

Have fun
-gks

Answer 3

web password are set by the web programming side, like php, asp, using .htaccess with apache