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.