Linked DB2 table in Access 2000 shows #Deleted on every record

[Klemens]

The linked table has a bigint in primary key columns.
I've read that service pack 8 on Jet should solve this but it didn't.
Are there any other solutions?

Thanks
Klemens

[Bob C.]

Access can only interpret tinyint, smallint and int as byte, integer
& long integer respectively.

I changed my sql table "bigint" fields to "int"(I wanted long integer
anyway) and the #DELETE's all went away. Works fine now, and the
subform that previously would not allow edits to exisiting
records("this record has been changed by another user since you
started editing") accepts the changes.

Check your relationships in both SQL and Access before you use the
tables.

Bob

[Klemens]

I don't have the ability to change the datatype of the columns.
I tried to create a view wich converts datatype to character. But this only
works for select and update but not for inserts as access tries to update
the primary key column on insert, which is not allowed on views with scalar
functions on the updated columns.
Any other idea?

Thanks
Klemens

"Bob C." <bc******@bmghomes.com> schrieb im Newsbeitrag
news:2e**************************@posting.google.c om...

Access can only interpret tinyint, smallint and int as byte, integer
& long integer respectively.

I changed my sql table "bigint" fields to "int"(I wanted long integer
anyway) and the #DELETE's all went away. Works fine now, and the
subform that previously would not allow edits to exisiting
records("this record has been changed by another user since you
started editing") accepts the changes.

Check your relationships in both SQL and Access before you use the
tables.

Bob