ODBC update-Problem

From: Sven Kunze <svenkunze_at_aol.com>
Date: 1998/03/09
Message-ID: <19980309232900.SAA02905@ladder02.news.aol.com>#1/1

Urgend and important - please help !

I have an update problem in Access 2.0 editing in ODBC-linked tables from Oracle and with
VB 4.0 (16 bit) using the update-method.

If I try to save data updates I get this error message: "Data has changed by another user". But there are no more user´s.

When I change data with an update querry in access or via sql-statement in vb, all is ok.

Same problem with the vb-delete method or deleting in access-tables.

The tables have a primary key and the problem occurs also in tables which have only character columns.

I also refreshed the links.

Sometimes in Access I can update the rows I just inserted, but not other (older) rows.

Any idea ?

***
*I use ORACLE 8.0.3.0.0 on NT Server 4.0 (SP3), TCP/IP, and Client NT 4.0 (SP3) with Access 2.0 / 97 / Visual Basic 4.0 *(16-Bit) with ODBC 8.0.3.0.0 32-Bit.

* ->>>Answer please to SvenKunze_at_AOL.com<<<-
*** Received on Mon Mar 09 1998 - 00:00:00 CST