Ok, I created a login section but would like to redirect depending on the username entered. I have an access database with a username and url column. If the user1 enters his info, then he will be directed to the user1 site. If user2 enters his info, he will be directed to the user2 site, etc. Any help will be greatly appreciated. I understand initially I can redirect to an in between page which would hold the if statement and then redirect. Thanks!

When the user logs in the next page is your redirect page, which is just ASP code, no HTML so it runs entirely at the server, with a recordset with a source something like:

RecodsetName.Source = "SELECT RedirectURL FROM UserTable WHERE UserName LIKE '" & Session("MM_Username" & "'"

Then after all the recordset code:

<% Response.Redirect(RecordsetName.Fields.Item("RedirectPage".Value) %>





Regards

Owen.

Multiple Parameter UD4 / Access 2000 Database Search Tutorial:
www.tdsf.co.uk/tdsfdemo

Owen, thanks very much for helping me out. This is the code on the redirect page:

<%
set rClients = Server.CreateObject("ADODB.Recordset"
rClients.ActiveConnection = MM_hexClients_STRING
rClients.Source = "SELECT URL FROM clientList"
rClients.CursorType = 0
rClients.CursorLocation = 2
rClients.LockType = 3
rClients.Open()
rClients_numRows = 0
%>
<%
rClients.Close()
%>

<% Response.Redirect(rClients.Fields.Item("RedirectPage".Value) %>

This is the error I get:

ADODB.Field error '800a0e78'

Operation is not allowed when the object is closed.

/clients/redirect.asp, line 17

I'm not sure what the problem is.

Move the redirect line above the recordset close:

<%
set rClients = Server.CreateObject("ADODB.Recordset"
rClients.ActiveConnection = MM_hexClients_STRING
rClients.Source = "SELECT URL FROM clientList"
rClients.CursorType = 0
rClients.CursorLocation = 2
rClients.LockType = 3
rClients.Open()
rClients_numRows = 0
%>
<% Response.Redirect(rClients.Fields.Item("RedirectPage".Value) %>
<%
rClients.Close()
%>



Regards

Owen.

Multiple Parameter UD4 / Access 2000 Database Search Tutorial:
www.tdsf.co.uk/tdsfdemo