Accessing an index in a Linked Table

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I spun my tables out to another database and then
linked my "Application" MDB to the "Table" MDB.
I now get an error message with the following line of
code:

Set rst = dbs.OpenRecordset("Dockets")
rst.Index = "DocketNumber"

The error occurs on the second line. Error message
is "Operation is not supported for this type of object.
(Error 3251)"

I read somewhere last night that some table properties
(such as indexes) are not "passable" from a linked table.

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

Thanks,
Jonathan Mulder
Red Bluff, CA
 
QUESTION --> How can I access my index in a linked
table?
Click to expand...

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.
 
Back
Top