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"
>  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
> >> 
> >> 
>