View Single Post
  #1  
Old August 23rd, 2004, 06:59 PM
external usenet poster
 
Posts: n/a
Default Accessing an index in a Linked Table

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