Microsoft KB Archive/123598

= ACC2: Attached Paradox 4.0 Table Displays "#Deleted" =

Article ID: 123598

Article Last Modified on 7/5/2002

-

APPLIES TO


 * Microsoft Access 2.0 Standard Edition

-



This article was previously published under Q123598



Moderate: Requires basic macro, coding, and interoperability skills.



SYMPTOMS
When you attach a Paradox version 4.0 table with a single primary key that is a one-character alphanumeric field, "#Deleted" is displayed in all the records in the table.



RESOLUTION
Increase the FieldSize property setting of the primary key field, add another field to the primary key, or delete the current primary key.



STATUS
Microsoft has confirmed this to be a problem in Microsoft Access version 2.0. This problem no longer occurs in Microsoft Access version 7.0.



Steps to Reproduce Problem

 * 1) Create a Paradox 4.0 table with a one-field primary key that is a one-character alphanumeric field.
 * 2) Add a record to the table.
 * 3) Start Microsoft Access and open any database.
 * 4) Attach the table you created in step 1.
 * 5) View the table in Datasheet view. "#Deleted" is displayed in the record.

