How to limit number of records found a query

[dlbdennis]

I would like to keep users from using a % to query my db as it puts a load on the server. If I could limit the max records returned to 30,000 it would be wonderful.
Here is the select code from a multi-part form.

 strSQL = "SELECT * FROM TABLE WHERE "
      
      for x = 0 to UBound(arrParams)
         if arrParams(x, FIELD_MINVAL) <> "" or arrParams(x, FIELD_MAXVAL) <> "" then
            if x > 0 and strSQL <> "SELECT * FROM TABLE WHERE " then
               strSQL = strSQL & " AND "
            end if

[ADezii]

Why not use the SQL SELECT Top Clause?

[dlbdennis]

I tried to get that to work with no luck

[dlbdennis]

Ok thanks I got it to work