Tables: How to perform Seek on Linked Tables

(Q)    Can I perform Seek and Index on linked tables?

(A)    Directly, No.  But you can use the following function which will allow you to do this.

(watch out for line wraps.  It's just a single line of code.)

'************ Code Start ***************
'This code was originally written by Michel Walsh.
'It is not to be altered or distributed,
'except as part of an application.
'You are free to use it in any application,
'provided the copyright notice is left unchanged.
'
'Code Courtesy of
'Michel Walsh

 Public Function OpenForSeek(TableName As String) As Recordset
' Assume MS-ACCESS table
    Set OpenForSeek = DBEngine.Workspaces(0).OpenDatabase _
                    (Mid(CurrentDb().TableDefs(TableName).Connect, _
                    11), False, False, "").OpenRecordset(TableName, _
                    dbOpenTable)
End Function
'************ Code End ***************

Just use:
    Dim rst as Recordset
    set rst=OpenForSeek("TableName")

and you can use rst.Seek and rst.Index on linked table TableName.