"#Deleted" is displayed in my cells

[Guest]

I have linked to a mainframe DB2 table and when I try to open the table or
run a query against it, the only thing that display is "#Deleted" in every
cell. I know there is data in the table as I can query using Excel and get
the correct results. Using the same simple query in Access, I retrieve the
correct number of rows but they all contain the same "#Deleted" message in
each cell. I can also import the table from DB2 into Access and the data
displays correctly, but I need to have it linked.

I have links to other DB2 tables on this mainframe and the results are fine.
Anybody have any ideas? Thanks.

 

[Douglas J. Steele]

Does the primary key include a fixed-length text field for the tables that
are exhibiting the problem? If so, try changing the field to VARCHAR
instead. You should also ensure that you've got the latest service pack for
the Jet database engine.

(I'm basing this advice on http://support.microsoft.com/kb/264766)