By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
426,122 Members | 906 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 426,122 IT Pros & Developers. It's quick & easy.

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

P: n/a
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
Nov 13 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
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
Nov 13 '05 #2

P: n/a
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

Nov 13 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.