DB2 Linked tables: Delete & Update rights

  • Thread starter Thread starter Miela
  • Start date Start date
M

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
 
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.
 
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
Click to expand...

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.
 
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.
 
Back
Top