Re: add index to linked table

How does the problem relate to Delphi? ... Well ... ummm ... because I'm
using Delphi code to try to do this. Thanks for asking.



"Kevin Frevert" <kevin@xxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:42e3feca@xxxxxxxxxxxxxxxxxxxxxxxxx
> 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?
> >
> >
>
>


.