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(at)westcountrypublications(dot)co(dot)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(at)geneseo(dot)edu]
>> Sent: Thursday, July 19, 2001 4:22 PM
>> To: Pgsql-Odbc(at)postgresql(dot)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(at)geneseo(dot)edu
>>
>>