RE: Access 97, Error - Data changed by another user, Copy to Clip board or Drop changes - Mailing list pgsql-odbc

From Henshall, Stuart - WCP
Subject RE: Access 97, Error - Data changed by another user, Copy to Clip board or Drop changes
Date
Msg-id E2870D8CE1CCD311BAF50008C71EDE8E01F74619@MAIL_EXCHANGE
Whole thread Raw
List pgsql-odbc
Are you using Row Versioning? This uses the xmin field so that it will be
necessary to relink the tables. MS Access can then use the primary key and
xmin to identify a row as exactly the same row it earlier retrieved. If you
don't do this access does uses all the fields (bar memo and BLOB's) in the
where condition of the update. This can lead to precision problems with
floats.
You will also need this in the back end to allow comparison of int4 to xid:
create function int4eq(xid,int4)
    returns bool
    as ''
    language 'internal';

create operator = (
    leftarg=xid,
    rightarg=int4,
    procedure=int4eq,
    commutator='=',
    negator='<>',
    restrict=eqsel,
    join=eqjoinsel
);
- Stuart
(Sorry if this is wrongly addressed as the mail digest sometimes contains
character sets my Outlook doesn't recognise and therefore just gives me one
big text file)

ORIGINAL MESSAGE:
Access 97

Error - Data changed by another user, Copy to Clipboard or Drop changes

I got the above error message various times and could not understand what
was causing it.
Finally we figured out that we had a numeric field with to many digits
beyond the decimal point and access was not able to handle it.

Instead of an inteligent error message though it claimed someone else had
changed the data.
The solution was to round the data down to something access could handle.


respectfully,
Joseph


pgsql-odbc by date:

Previous
From: "Henshall, Stuart - WCP"
Date:
Subject: FW: Data export using Microsoft Access
Next
From: Enrico Gava
Date:
Subject: ODBC performance with ADO