Access 2K on p2p W2k Pro network.
Is it possible to specify a query that would only return N lines/records? I have a fairly large table several thousand entries which in turn are related to other tables. I need to scroll through either an unfiltered or filtered subset of these records. Problem is everytime I apply a filter it seems like the recordset is being completly populated which causes a major hesitation across this small p2p network (This data is shared between several users)
In code I think I could do a Find first unique followed be a loop of N Find Next ... not sure how efficient this would be ... a query would be preferable.
Is it possible to specify a query that would only return N lines/records? I have a fairly large table several thousand entries which in turn are related to other tables. I need to scroll through either an unfiltered or filtered subset of these records. Problem is everytime I apply a filter it seems like the recordset is being completly populated which causes a major hesitation across this small p2p network (This data is shared between several users)
In code I think I could do a Find first unique followed be a loop of N Find Next ... not sure how efficient this would be ... a query would be preferable.
