access database access

[tfinch]

Hello, I took over a site that is password protected in certain areas. I saw a database on the site with a password list on it. Depending on the word you type in, it will take you to different sections of the site. I looks simple enough but when I try to get it to work, it doesn't. Does anyone have some help links for ASP? It looks like there are only two pages for this task, plus the database, which is in Access.
What I want to do is make a database that will direct where people go depending on what they type in. For example, business will take you to business/index.htm
Any help is appreciated.
TF

[ADAM Web Design]

Well...in the case of logins/passwords, it really depends on what you're trying to accomplish or do.

The simple explanation (with no code) is this:

Set up Access table with login, password, and redirect URL.
Set up form for user to input login/password.
Check to see if Login/password inputted match any in the Access table.
If they do, retrieve the URL and redirect them (Response.Redirect) to the appropriate section.

[vivekar]

Since you want to direct where people go depending on what they type in, *occasionally* you might run into some trouble.

Try to implement a good 404 page ( in asp) which collects and shows the recently visited pages.

[Easywebdev]

A "good" 404 page.

Lets define that. A 404 is encountered when a webpage cannot be found under a particular site. We have all seen the remnants of the code red and nimda virii with hits on our error logs for some_silly_windows.dll

A "good" 404 page IMHO should be a php/shtml file that is able to record the users browser, ip and time of error and present the user with a choice of a) go to the sites homepage and try to locate what they are looking for or b) be directed to a form they can fill in detailing what they tried to find with the parameters (browser, time, page) already passed to the script and the results emailed to the webmaster.

If you are getting hits related to bots/virii then they are not going to click the links to your homepage or fill in a form detailing the problem.

Some people can't/won't be bothered to investigate 404's but oft times they can be a source of keywords a person uses to search for a site in your marketing niche.

I for one would rather know what the searcher was actually looking for when they hit my site.

A "bad" 404 just says page not found.

Thoughts?

[paulhiles]

I for one would rather know what the searcher was actually looking for when they hit my site.

A "bad" 404 just says page not found.

Thoughts?

Excellent post, if you want to start a new thread using the bulk of your post above to kick it off - be my guest! :o)

[tfinch]

Thanks for the tips. What I was looking for was a type of code to use to direct people to certain sections of the site that is already complete. For example: someone types "work" and it takes them to the work section of the site, which is in a folder on the site. I am not familiar with VB or ASP so I was hoping to get some help here. Any other ideas? Thanks again.

[Easywebdev]

My apologies to you tfinch, I dragged your post off topic by jumping on the "good 404" bit.

To reply to you original post, in order for the site you described to work there has to be a script to parse the user input (username/password) which is then checked against a database of valid username/password combinations and if a match is found then the script redirects the user to certain parts of the site.

I would assume that the first page is a html page with a form and the input is passed to the second (asp) page to validate the user and redirect them.

Without seeing the code that is used to parse the input and do the redirection its nigh on impossible to provide any help.

If you could post the code and what you are trying to add/achieve then I may be able to give you a more informed answer.