Re: Can't update a row from MS Access 7.0

Sounds as though you may have floating point data in the PK, (although this may happen with floating point data period if numeric rounding is occuring). the issue is that when Jet goes to do the update it uses a syntax similar to:

UPDATE EMP SET EMPNO=xxx, ENAME='xxx' where EMPNO=yyyy, ENAME='yyyy'

where xxx are the new values and yyyy are the old values. If the numbers get rounded when read fromOracle, then they don't exactly match so the update fails, so Jet thinks the data changed whilst you were thinking about updating.

Best approach might be to constrain the number column precision in Oracle to a closer match for Access to prevent rounding. This can alos happen with CHAR columns in Oracle as Access will not space pad them when comparing, so again no match, and no update. Received on Wed Feb 25 1998 - 00:00:00 CST