Thread: RE: Access 2000 and ODBC driver Data changed by another user, Cop y to Clipboard or Drop changes

Oops, sorry forgot a little bit of script for the backend:
create function int4eq(xid,int4)
    returns bool
    as ''
    language 'internal';

create operator = (
    leftarg=xid,
    rightarg=int4,
    procedure=int4eq,
    commutator='=',
    negator='<>',
    restrict=eqsel,
    join=eqjoinsel
);

This should give a suitable a suitable operator. I think theres an MS Access
FAQ on odbc.postgresql.org and on techdocs.postgresql.org which may also
help you
- Stuart

> -----Original Message-----
> From:    Maryann F Stopha [SMTP:stopha@geneseo.edu]
> Sent:    Friday, July 20, 2001 3:16 PM
> To:    Pgsql-Odbc@postgresql.org
> Subject:    Re: Access 2000 and ODBC driver Data changed by another
> user, Cop y to Clipboard or Drop changes
>
> Hi Stuart, thank you for your reply.
>
> I turned on row versioning, relinked the tables, and I'm now getting ODBC
> --update on a linked table 'organizations' failed.
>
> Error while exectuing the query;
> ERROR: Unable to identify an operator '=' for types 'xid' and 'int4'
> You will have to retype this query using an explicit cast (#7)
>
> Anyone have any ideas on this one?
>
> Maryann
>
>
> On 7/20/01 5:32 AM, "Henshall, Stuart - WCP"
> <SHenshall@westcountrypublications.co.uk> wrote:
>
> > Are you using row versioning? If not give it a go (you'll need to relink
> > tables after enabling)
> > - Stuart
> >
> >> -----Original Message-----
> >> From:    Maryann F Stopha [SMTP:stopha@geneseo.edu]
> >> Sent:    Thursday, July 19, 2001 4:22 PM
> >> To:    Pgsql-Odbc@postgresql.org
> >> Subject:    Access 2000 and ODBC driver Data changed by another user,
> >> Copy to Clipboard or Drop changes
> >>
> >> Hi,
> >>
> >> I'm working on a machine that was upgraded to office 2000.
> >>
> >> I updated the odbc driver to the most recent, and I'm getting the -Data
> >> changed by another user, Copy to Clipboard or Drop changes message
> (data
> >> is
> >> being accessed by another)- error.  We can't modify or add any data in
> the
> >> database from Access because of this error.
> >>
> >> This does not happen in Access 97.  Does anyone have any ideas as to
> why
> >> Access 2000 will gives error?  There's no numeric data in the database,
> >> it's
> >> all text.
> >>
> >> Thanks,
> >> Maryann Stopha
> >> --
> >> Web Development Professional
> >> Computing & Information Technology
> >> SUNY Geneseo
> >> 716.245.5577
> >> stopha@geneseo.edu
> >>
> >>
>