Re: Acc20: Write-conflict on records in newly created Oracle-Tables

From: Stefan Niemeyer <snie_at_izb.de>
Date: 1996/08/16
Message-ID: <4v13ru$5h1_at_izb.izb.de>#1/1

ms_at_dream.hb.north.de (Martin Schroeder) wrote:

>...
>We create a new table like another, add the keys, copy the data from the
>source table -- and when I then attach this table with MS-Access, I get
>a write-conflict-warning from MS-Access on _some_ records in the table
>(but not all!). :-(

It would be helpful to know what kind of error message you get.

Anyway, make sure that you use the Oracle ODBC driver 1.11.002 or any newer version if there exists one. The old 1.10.xxx made some problems. I guess the problem is a NUMBER field in your Oracle table. Define your number fields just as big as you need them, e.g. NUMBER(10,3). I'm not sure if the ODBC driver 1.11.002 still have this problem but the old one definitly had them. This error only happened with some records because the numbers need to get converted to binary and back to decimal and some numbers "suddenly" have digits far behind the decimal point where Oracle still handles them an Access doesn't. So these numbers seem to be "different" and cause some trouble.

Ciao

        Stefan

---

Office: snie_at_iZB.de
Private: Stefan.Niemeyer_at_munich.netsurf.de URL: http://homepages.munich.netsurf.de/Stefan.Niemeyer Received on Fri Aug 16 1996 - 00:00:00 CEST