Linking to Oracle table - URGENT

[citychap26]

Hi Guys,

Sorry for the URGENT bit in the title. However it is causing me major brain ache.

I remember from my Sybase days that a Sybase table needed to have an index on it to be updateable from MS Access. I have now graduated to Oracle. Is this still the case???

I am using Access97.

I created a unique index on the Oracle table and I can update it. However why does Access insist on this?

Cheers

SK

 

[PHV]

Access must have a way to uniquely identify each record to be sure to update the right one.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[citychap26]

Thanks )

Here's a tip. Don't use an Append query to update a linked table to Oracle it takes ages....

Cheers

SK