MS Access link to DB2 shows #delete in all fields of some tables

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Diane P - 28 Feb 2008 18:12 GMT

I am linking to DB2 database using ODBC. When I open some of the tables
there are rows and columns but all of the field contents show #delete.
When I open other tables the rows and columns display valid data.

I have another database that is the equivalent to this one only it is
Oracle. Those tables all show data correctly.

Any suggestions.

Reply to this Message

Rick Brandt - 28 Feb 2008 23:48 GMT

> I am linking to DB2 database using ODBC. When I open some of the
> tables there are rows and columns but all of the field contents show
[quoted text clipped - 5 lines]
>
> Any suggestions.

Usually means the primary key is a DataType that Access doesn't have an
exact equivelant for. Sometimes it only affects table datasheet view and
not usage in forms (so you can just ignore it). Other times you pretty much
have to use passthrough queries instead of links.

Signature

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

Reply to this Message