Hi i am new to ASP & SQL, so the problems i have:-

I am designing an intranet for the company i work for. I want to redirect a page based on there NT Username. I will store the usernames & access levels in a SQL database which i can do via importing an Excel spreadsheet, but i then only want certain people to access the search & update page, and everyone else to gets the search only page. I know how to get the LOGON_USER details but i dont how to get the redirect to work.

They also want me to do is create a log file for everytime someone updates a persons details. Details to save are there NTUsername & the persons name that was updated.

The last thing i have to do is stats page for the amount of searches per person, and create a webpage to display these stats (both searches via NTLogon & number of searches per person on the database), so they can see who gets the most searches.

Any help is appreciated :)
Lee

to redirect, use <%Response.Redirect "xxx.asp"%>

to find the count, use
        Set PageCnt = Server.CreateObject("MSWC.PageCounter")
    PageCnt.PageHit()
    Hits = PageCnt.Hits

i hope this is what you're asking.