I have a simple, left-join view that returns about 10000 records.

If I open the view directly in Access 2000 through the Database window, I
can quickly scroll through all of the records in a couple of seconds.
However, in a simple form based on the view without filters or sort, and set
to return 200000 records, scrolling through that dataset takes minutes.

Any ideas on why this loss of performance might be occurring?

Clustered Index Not Working
Select distinct problems
Top 1 query problem
UPDATE varchar(max) column using INNER JOIN with SQL2005
Newbie question for Report Server