>My form uses data from a view of an Access table (mde). The table has about 22,000 records (and growing). When I USE the view, it takes about 15 seconds to open the view. On the status bar, you can see the record counter counting up.
>Is there anything I can do to speed up opening this view? What is taking so long - are all these records being read into memory?
>Thanks for any help or suggestions.
All those records are being read and copied into a temporary cursor on your hard drive to be used by VFP.
Does the query have a filter criteria (WHERE clause) and is it optimized or are you simply returning an entire table to be viewed in VFP? If the latter, then you can't optimize it but you might try re-designing your application to see if you can avoid this. Set it up to bring over fewer records after asking for some criteria to use to filter the result set. If the former, do you have indexes created for the fields you are querying against? You need to do this to optimize your searches.
HTH.
Larry Miller
MCSD
LWMiller3@verizon.netAccumulate learning by study, understand what you learn by questioning. -- Mingjiao