Re: add index to linked table

John,

Since your using Access, how does the problem relate to Delphi?

krf

"John Provine" <xxx@xxxxxxx> wrote in message
news:42e3c1fc$1@xxxxxxxxxxxxxxxxxxxxxxxxx
> 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: add index to linked table
    ... how does the problem relate to Delphi? ... >> I'm trying to add an index to a linked Oracle table. ...
    (borland.public.delphi.database.ado)
  • add index to linked table
    ... I'm trying to add an index to a linked Oracle table. ... The ADO function call ... but all I get is "invalid argument". ... at which point it won't let you edit the table. ...
    (borland.public.delphi.database.ado)