Rs.Open "SELECT * FROM tblUsers WHERE tblUsers.username = '" & uname & "';", Conn, 1,3

This is what I have as my log in script, and it works if the name exists, but if it doesn't, it tries to deal with it by giving it an error. I want to deal with it myself, like this:

if not rs.EOF then
'things that are set if there are no entries
end if

Possible?

Absolutely possible. Not the best way to go about things, but possible.

If the table doesn't exist and you try to query it, the database will throw an error to tell your asp script something went wrong, and it can't just go on. You don't get an empty result set.

On Error Resume Next

rs.Open "Select * From a_table_that_doesnt_exist"

If rs.EOF or rs.BOF ...

If you wanted to get really sophisticated but abstract, you could make a routine to query the mSysObjects table - I'm assuming you're using Microsoft Access. There's a type and a name column, so you can write code that knows whether a table exists before trying to query it.

if not rs.EOF then
'things that are set if there are no entries
end if

Would handle the End Of File error but you should handle the Beginning Of File error as well

or check the error object from the ADO Errors collection

On Error Resume Next

objRS.open ....  


if objRS.Errors.number <> 0 then
    do error handling
end if

http://www.devguru.com/technologies/ADO/8591.asp
http://www.devguru.com/technologies/ADO/8757.asp

A list of ADO error codes can be found at http://www.devguru.com/technologies/ADO/8596.asp


for no records existing the error is adErrNoCurrentRecord

IF you use the error object make sure that you clear it before calling a method that may raise an exception.