Indexes in Linked tables

[Crookshanks]

Good afternoon,

In my application I use linked tables. Now, I meet a problem (error = operation not supported with this type of object) when I want to search something in that tables using an indexed field, something like this:

rsInt = db.openRecordset("tbl_intermediars")
rsInt.index = "primary key"
rsint.seek "=", 1

Now it seems that that I can not use the indexes of a table when it is a linked table. Why does this happen, and who has a solution? Do I need to "loop" through all records with a do while-statement?

Kind regards,

 

[RickSpr]

The Index and Seek properties only exist for a table-type recordset. You can't open a table-type recordset on a linked table. You will have to convert to using a dynaset-type recordset, and trust Jet to select the best index.

Rick Sprague
Want the best answers? See faq181-2886
To write a program from scratch, first create the universe. - Paraphrased from Albert Einstein

 

[Crookshanks]

OK, thanks for your quick answer. But could you please tell me how to start this conversion to dynaset-type.
What should I change in my code.

 

[RickSpr]

Well, I have almost never used table-type recordsets so I'm not sure this covers it, but for the statements
rstInt.Index = "Primary Key"
rstInt.Seek "=", 1
you would substitute
rstInt.FindFirst "<primary key field name> = 1"

Hope that helps.

Rick Sprague
Want the best answers? See faq181-2886
To write a program from scratch, first create the universe. - Paraphrased from Albert Einstein