Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: MS Access ODBC-linked tables from Oracle corrupt data in LONGs
Does the linked table have a primary key defined on it at the Oracle level?
If so, when you create the link, does it ask you to specify a unique
identifier for the table (for updating/inserting records etc)? It
shouldn't, as this should be derived from the primary key. Try deleting the
linked table from Access and re-linking again.
daveatkins wrote in message <8c0gtq$pgj$1_at_nnrp1.deja.com>...
>I am using MS Access 2000 via ODBL linked tables to Oracle 8. Sometimes
>when I edit a row through a form, when I click on the text entry area,
>a bunch of data from another row appears. Any idea where this could be
>coming from?
>
>Thanks
>
>
>Sent via Deja.com http://www.deja.com/
>Before you buy.
Received on Thu Mar 30 2000 - 19:46:24 CST
![]() |
![]() |