is there a simple way to limit the total number of records contained within a recordset, the database contains over 35000 records and i need to be able to set a maximum number that can be retrived at any one time.

What database are you using? Are you just trying to avoid displaying the 35000 records, or retrieving them all together?

If you just want to avoid showing them - use recordset paging.

If you want to avoid retrieving them:
MYSql uses LIMIT
SQL uses TOP

Hi
im using access 2000 with windows 2003 server

i need to restrict the number of returned records on a standard account to 1000 and 5000 on a payed account. otherwise im just giving away all my hard work compling the data.

I think this will work in Access

SELECT TOP 1000...

using this code

SELECT TOP 1000
FROM casedata
WHERE ((casedata.regdate<=Date()-42))

Got this error



Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E14)
[Microsoft][ODBC Microsoft Access Driver] The SELECT statement includes a reserved word or an argument name that is misspelled or missing, or the punctuation is incorrect.
/tri/result.asp, line 92




Edited by - filco on 22 Mar 2004 00:07:19

OK

got it working, missed out the *

Thanks for all your help.

SELECT TOP 1000 casedata.*
FROM casedata
WHERE ((casedata.regdate<=Date()-42))