>Thanks that seems to help. But I was just wondering what I could do to help speed up the retriving of the view. I am simple retrieving information for one customer - I have an index based on that field but that doesn't seem to help the executing the view. The recordset if around 120,000 records. Any idea if any that I am doing incorectly.

Hard to say without seeing your code, view definition, and indeces. Start with a basic understanding of Rushmore. There is a KB article on my web site that will help. Are you using view paramenters? Make sure there is an index on the field for the parameter. How are you retrieving the data? Is it somthing like:

SELECT MyTable
lcViewParameter = "SomeValue"
REQUERY()