Index

[cainemart]

If you have an index set for a table in one database, and in another database you are linked back to that indexed table, does the index apply to the linked table.

thanks

 

[LarryDeLaruelle]

As far as I know, they do.

I use linked tables extensively and when I look at the index for any of those linked tables, all indexes are shown. Larry De Laruelle
ldelaruelle@familychildrenscenter.org

 

[cainemart]

I'm sorry, I left out the part about trying to open the table by using a recordset. The recordset will open the table as a dynaset type not a table type. Since it isn't a table type the index does not move over.

 

[LarryDeLaruelle]

Right you are!

How were you intending to use the index?

If the recordset is based on a query or sql, could you use an order by clause to arrange the records? Larry De Laruelle
ldelaruelle@familychildrenscenter.org

 

[cainemart]

Actually, this is someone else's code. I had to break this big database up into smaller parts and when I did I started getting the error. He used the index for searching.

CM

 

[jebry]

Hi CM!

When you open a table as a recordset the table automatically opens as a tabletype if the table is local. Linked tables by default are snapshot(I think) but can be opened as dynasets. To search a table type recordset you use the Seek method, which requires an index. To search a dynaset you use the FindFirst method which does not require an index.

hth
Jeff Bridgham
bridgham@purdue.edu

 

[LarryDeLaruelle]

Jeff is right, you can't use seek with on a table in a split/back end database.

I think though that such recordsets are dynaset by default. Larry De Laruelle
ldelaruelle@familychildrenscenter.org

 

[cainemart]

Thanks for the help! I used an SQL statement when opening the recordset instead.

CM