Accsess Databases and HTML

[minusbfold]

I have a question and I don't know if anyone can help me or not. I have an access data base filled with account numbers and I want people to be able to log on to a simple html page were they can put in a login and password that is on the access database to get into another page with some sensitive information that only the customer is allowed to see it doesn't have to be really tightly secured just something simple if anyone knows how to do this please respond thanks.

Rich

[the tree]

Yes this can be done.
I'm not really familiar with acceess databases, but with any databases you'll need a server side scripting language like php or asp.

[sciguyryan]

Have a look at this, it maybe useful if you wish to use PHP:


http://www.phpfreaks.com/tutorials/61/0.php

RyanJ

[ray326]

If you have an Access database then does that mean you're running your web site on a Windows server?

[PeOfEo]

It is very easy to use access with asp and asp.net if you are infact on a windows server. I would tend to think access would work on linux/unix since access is a file db and not a server db.

I wrote an article about a very rudimentary data driven login system with asp.net that uses access
http://www.webreference.com/programming/asp/quasi/
obviously this is not the most secure thing in the world (heck I could get in with sql injection), so if the data is sensative some fundamental things will need to change (including the fact that this uses access, access is not good for high security stuff because it is just a file on the server).

[ray326]

Can an Access database be used directly by IIS for authentication? I.e. a table with a prescribed schema acts as a replacement for a flat password file for basic authentication. There are modules for Apache that allow it to work that way, hence my host platform question.

[minusbfold]

See I took over a web site for the company that I work for and the [person who worte the code did it about 6 years ago. Its some written in asp and a login everyting is set up but when i put it on the new server the same way it was set up on the old server it will not work

[minusbfold]

All I really want to do is have somthing with about 400 account numbers listed in it and lets people login with the acount number and the password being the same as the account number and bring them to a certain page on the site.
thats it

[ray326]

Are these employees or are they external? If the former then you can authenticate against your NT domain then associate that login with an account.

[minusbfold]

It's on windows 2000 server. I just need to find a way to have people login with a user name and password that is authenticated by a huge list of user names and passwords in an accsess data base that then forwards them to a couple pages.

[PeOfEo]

Originally posted by ray326
Can an Access database be used directly by IIS for authentication? I.e. a table with a prescribed schema acts as a replacement for a flat password file for basic authentication. There are modules for Apache that allow it to work that way, hence my host platform question. I am not sure actually. I know you can enable forms auth and then use access with that. Forms auth is pretty straight forward and easy to work with.

[ray326]

Originally posted by minusbfold
It's on windows 2000 server. I just need to find a way to have people login with a user name and password that is authenticated by a huge list of user names and passwords in an accsess data base that then forwards them to a couple pages. Do all these users have IDs in your domain?

[minusbfold]

Not on the domain the login and passwords are all in a accsess database.

[minusbfold]

Im getting this error.

I have iot set up already from the person who did the iold sit it just doesnt seem to work on this server im using IIS5 and i can get to the asp login page but when i put in a user name and password it just wont work. I checked the line 366 in the js file and there is nothing wrong with it.

HTTP 500.100 - Internal Server Error - ASP error

Technical Information (for support personnel)

Error Type:
Provider (0x80004005)
Unspecified error
/media/IIS_Gen_3.0_Recordset.js, line 366


Browser Type:
Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1)

Page:
POST 151 bytes to /Price Login.asp

POST Data:
CustomerNumber=12028325&password=12028325&FormButton1=Login&Recordset10_Action=&Recordset10_Position=FIL%3AORD%3AABS%3A1KEY%3A25818302PAR%3A&_Bindings=

Time:
Thursday, January 13, 2005, 8:02:18 AM

[PeOfEo]

what js file, are you using the code from my article? My article is for asp.net, not asp classic.