DB2 Linked tables: Delete & Update rights

[Miela]

Hi,

Please can somebody help me. I have a few DB2 Linked tables in a MS Access
database. I have full rights (delete, insert, select, update) to these DB2
tables in the back-end, but I am unable to delete any records when I open
these tables in access. I am also unable to update data using Update queries
in Access.

Many thanks in advance

 

[June7 via AccessMonster.com]

By DB2 do you mean dBase II program? Are these tables still being used by a
dBase application? If not, why not convert to Access (simple import operation)
? If still used by a dBase application, could there be some locks in place by
that app?

 

[Miela]

Thanks for the reply. No by DB2 I mean IBM DB2 tables linked to access as
ODBC tables. I use access as a UI and want to update records in the DB2
Backend tables.

 

[Rick Brandt]

Hi,

Please can somebody help me. I have a few DB2 Linked tables in a MS
Access database. I have full rights (delete, insert, select, update) to
these DB2 tables in the back-end, but I am unable to delete any records
when I open these tables in access. I am also unable to update data
using Update queries in Access.

Many thanks in advance

Do the tables have primary keys or at least one unique index defined on
the server? Links to server tables with neither of those are read-only
unless you define which fields can be used to build a local unique index
within your Access file.

 

[Miela]

That is exactly the problem. The records were not unique. I forgot to add a
second field to make them unique.

Many thanks for your help.