add index to linked table

I'm trying to add an index to a linked Oracle table. The ADO function call
seems straightforward enough, but all I get is "invalid argument". I even
cut and pasted the example code from the online help. Same result.

I'm not actually sure it's even possible to do this. When you manually link
to an Oracle table, Access adds a primary key named "__uniqueindex", but the
index is not added to the Oracle database, so I'm not sure where it is. The
problem is that Access (or maybe it's ODBC) randomly loses the index over
time, at which point it won't let you edit the table. So I'm trying to find
a way to add the index back.

Anybody have any insights?


.

Relevant Pages

  • Re: Not able to edit fields in an editable datasheet form
    ... >I cannot edit the data anymore? ... Probably because the underlying query, or the table under *that*, is ... A linked Oracle table will only be updateable if it ...
    (microsoft.public.access.forms)
  • Re: add index to linked table
    ... how does the problem relate to Delphi? ... > I'm trying to add an index to a linked Oracle table. ... The ADO function call ...
    (borland.public.delphi.database.ado)