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

[Diane P]

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.

 

[Rick Brandt]

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.

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.