Re: Row-locking Problem in MS-Access via ODBC

From: Michael Carmack <>
Date: 1997/05/23
Message-ID: <5m4j58$>#1/1

Jens Waldorff ( wrote:
: Does the table with the row-locking problem contain column(s) with decimal
: (floating point) numbers ?
: One version (i can't remember the version no.) of Oracle ODBC driver has a
: problem converting certain decimal numbers (e.g. 86.4). Converting
: "dangerous" numbers generates wrong numbers with an extra digits at e.g.
: 17th decimalplace.
: I seems to be safe using FIX POINT numbers and Oracle ODBC driver ver.

Yes, the tables do have floating point numbers, but I don't believe that the problem is in the Oracle ODBC drivers. I am able to perform any changes I want through the ODBC Test applet that Oracle ships with the drivers; the row locking problem only raises its head when I'm using the Jet database engine in a Windows app, e.g. in Access or a Visual Basic app. (I've tested Jet 2.5 via 16-bit Access 2,0 and Visual Basic 4, and Jet 3 via 32-bit Visual Basic 5.)

"Villains, I say to you now:       |   Mike Carmack
 KNOCK OFF ALL THAT EVIL!"         |   Vulcan Dragon -==(UDIC)==-
    S P O O N !!!!    - The Tick   |
Received on Fri May 23 1997 - 00:00:00 CEST

Original text of this message