Något liknande kanske?!:
sida.asp:
<form name="search" method="post" action="search.asp">
<input type="text" name="strSearch"><br>
<input type="submit" name="submit" value="Sök">
</form>
search.asp:
strSearch=replace(request.form("strSerach"),"*","%")
Set Conn = Server.CreateObject("ADODB.Connection")
Conn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & server.MapPath("databas.mdb")
strSQL = "select * from tabellen where kolumnen like '%"& strSearch &"%'"
Set rs = Conn.execute(strSQL)
Do while not rs.eof
Response.write rs("kolumnen")&"<br>"
rs.movenext
loop
rs.close
set rs=nothing
conn.close
set conn=nothing
Response.write "<br><a href='search.asp'>Sök igen</a>"