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.


"June7 via AccessMonster.com" wrote:

> 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 wrote:
> >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
>
> --
> Message posted via http://www.accessmonster.com
>
>

On Fri, 14 Aug 2009 06:18:10 -0700, Miela wrote:

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


--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com

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.

"Rick Brandt" wrote:

> On Fri, 14 Aug 2009 06:18:10 -0700, Miela wrote:
>
> > 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.
>
>
> --
> Rick Brandt, Microsoft Access MVP
> Email (as appropriate) to...
> RBrandt at Hunter dot com
>