If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
On Mon, 23 Aug 2004 10:59:16 -0700,
wrote: QUESTION -- How can I access my index in a linked table? 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. John W. Vinson[MVP] Come for live chats every Tuesday and Thursday http://go.compuserve.com/msdevapps?loc=us&access=public |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Select records | Ricoy_Chicago | General Discussion | 6 | July 16th, 2004 07:12 PM |
Linked table getting Application Error | Eric | Mailmerge | 3 | June 13th, 2004 11:08 AM |
resize table from A4 size to A5 | ims | New Users | 3 | June 9th, 2004 01:05 AM |
How to find the index number of the table if it is a nested table. | OlgaP | Tables | 11 | May 25th, 2004 02:51 PM |
Determine Table Index Number in a Table Collection | Andrew | Tables | 2 | May 15th, 2004 03:36 AM |