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

From: "Henshall, Stuart - WCP" <SHenshall(at)westcountrypublications(dot)co(dot)uk>
To: "'lters(at)mrtc(dot)com'" <lters(at)mrtc(dot)com>
Cc: "'pgsql-odbc(at)postgresql(dot)org'" <pgsql-odbc(at)postgresql(dot)org>
Subject: RE: Access 97, Error - Data changed by another user, Copy to Clip board or Drop changes
Date: 2001-07-18 08:37:08
Message-ID: E2870D8CE1CCD311BAF50008C71EDE8E01F74619@MAIL_EXCHANGE
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Browse pgsql-odbc by date

  From Date Subject
Next Message Maryann F Stopha 2001-07-18 18:44:28 Access 2000 and ODBC driver Data changed by another user, Copy to Clipboard or Drop changes
Previous Message Henshall, Stuart - WCP 2001-07-18 08:09:32 FW: Data export using Microsoft Access