Peter,

Are you updating the view or requerying it? If you're requerying the view is the view parameterized or does it return all 36,000 records? If that's the case then that explains the 7 seconds. When you requery a view all of its records are copied from the base table to your view. You may be able to speed things up by setting the view's FetchSize to -1 (return all records at once). If that doesn't help you may want to consider changing the view to return a subset of the database.

>I am accessing a standard table in a Foxpro DBC container through and ODBC connection. You mean that a 7 second requery of the view is ok?