First off here is a lesson to help you debug. Put this tag at the top of every page that you creat in VBScript.
<% Option Explicit %>
that way any implicitly declared variables are not used.
OK that said look at your code. You have a recordset object called rs but you are then trying to work with it under RDS. So change the code to this
dim conn, strconn, rs
strconn = "DRIVER=Microsoft Access Driver (*.mdb);DBQ=" & _
set conn = server.createobject("adodb.connection")
'Create the recordset object
set rs = server.createobject("adodb.recordset")
rs.open "my_users", conn, 2, 2
'set recordset properties for control just created
rs.Server = "http://<%=Request.ServerVariables("SERVER_NAME")%>"
rs.Connect = conn
rs.SQL = "Select * from my_users"