INSERT Problems - Basic!

I created an application using Access and converted it to a MS SQL database - it worked well in access but I'm now having troubles with it in MS SQL - even just doing a simple insert.

To locate the problem, I created a simple table "Member" with only one field "FirstName" - a page with only one form field "FirstName" which goes to regchk.asp which has this code:
<%
strconn = "Provider=SQLOLEDB; "
strconn = strconn & "Data Source=PHSSQLWEBRPD2; "
strconn = strconn & "Initial Catalog=OPRS; "
strconn = strconn & "User Id=MYUSERIDHERE; "
strconn = strconn & "Password=MYPASSWORDHERE"

Set conn = Server.CreateObject("ADODB.Connection")
conn.ConnectionString = strconn
conn.Open


strSQL1 = "SELECT * " & _
"FROM Member"

Set rs = conn.Execute(strSQL1)
If rs.BOF AND rs.EOF Then

strSQL = "INSERT INTO Member(FirstName)" & _
"Values('" & request("FirstName") & "')"

conn.execute(strSQL)

Response.Redirect "success.asp"

Else
response.redirect("register.asp?signuperror=" & " UserName"& " " & "<b>" & username & "</b>" & " already exists, Please try another username" )

End If

rs.Close
Set rs=Nothing
rst.Close
Set rst=Nothing
conn.Close
Set conn=Nothing
%>

The page generates this error:
Invalid object name 'Member'.

/members/regchk.asp, line 16

which makes me think that it doesn't even recognize the table as existing?? Any ideas what I'm doing wrong? It's driving me crazy..


Please help! and thank you in advance!