filter by form hangs machine in access 2000 & SQL server 1

[Waynest]

I'm using access 2000 as a front end to sql server.<br><br>I've found that using filter by form (client side) with large recordsets invariably hangs my machine.&nbsp;&nbsp;The forms in question use select statements with 3 inner joins, but I suspect its just&nbsp;&nbsp;the number of records which causes the problem as I have similar queries on smaller tables (100s of recs rather than 1000s) which seem to work ok. I can avoid the problem by using the server filter by form option but does anyone know what causes access to hang?&nbsp;&nbsp;I use a high spec machine with bags of memory & disk space so it shouldn't be that...

 

[DougP]

There is a 1000 record limit by default.<br>Look in &quot;Tools&quot; menu &quot;Options&quot; Tehn &quot;Edit/Find&quot; TAB<br>You will see a 1000 setting in &quot;Don't display ....&quot;<br>change it to 2000 and see if that helps<br><br>Also Access by nature is NO wimpy program and its not happy on anything less than PII/PIII 450 or higher. <br>NT workstation 4.0 or Win 2000 Pro is the client of choice.<br>with at least 128 meg of RAM. 256 RAM preferred.<br>Productivity will go up exponentially on a Screamer, I've done tests. <p>DougP<br><a href=mailto: dposton@universal1.com> dposton@universal1.com</a><br><a href= > </a><br> Ask me how Bar-codes can help you be more productive.

 

[Waynest]

Doug<br><br>Thanks for the reply but I already tried the record limit - it just stops bringing over records when it hits the limit, it doesnt crash.&nbsp;&nbsp;And my machine is a PIII 550 with 256mb<br>so I doubt its the spec, although I'm forced to run win95 on it for reasons I wont go into.<br><br>Er, how can barcodes help you be more productive?