View Single Post
  #2  
Old August 24th, 2004, 03:17 AM
John Vinson
external usenet poster
 
Posts: n/a
Default

On Mon, 23 Aug 2004 10:59:16 -0700,
wrote:

QUESTION -- How can I access my index in a linked
table?


You cannot; nor can you use the SEEK method.

Two options:

- use the OpenDatabase method to open the backend database directly
(rather than using the linked table)
- or use the FindFirst method of DAO rather than the SEEK method. It
will make use of any indexes on the table, and while it might not be
as fast as SEEK in a careful timing competition, it's usually fast
enough to be indistinguishable to users.

John W. Vinson[MVP]
Come for live chats every Tuesday and Thursday
http://go.compuserve.com/msdevapps?loc=us&access=public