• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

6. Data > 6.5. Quickly Find a Record in a Linked Table

6.5. Quickly Find a Record in a Linked Table

Problem

You like to use the ultra-fast Seek method to search for data in indexed fields in your table-type recordsets, but the Seek method won’t work with linked tables because you can only open dynaset-type DAO recordsets against linked tables. You can use the Find methods to search for data in these types of recordsets, but Find is much slower at finding data than Seek. Is there any way to use the Seek method on linked tables?

Solution

The Seek method works only on table-type recordsets, so you can’t perform seeks on linked tables. However, there’s no reason why you can’t open the source database that contains the linked table and perform the seek operation there. This solution shows you how to do this.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint