ACC2: Attached Paradox 4.0 Table Displays "#Deleted"

Article translations Article translations
Article ID: 123598 - View products that this article applies to.
This article was previously published under Q123598
Moderate: Requires basic macro, coding, and interoperability skills.
Expand all | Collapse all

On This Page

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.

MORE INFORMATION

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.

REFERENCES

For more information about attaching Paradox tables, search for "Paradox files," and then "Importing and Attaching Paradox Tables" using the Microsoft Access Help menu.

Paradox is manufactured by Borland International, Inc., a vendor independent of Microsoft; we make no warranty, implied or otherwise, regarding this product's performance or reliability.

Properties

Article ID: 123598 - Last Review: July 5, 2002 - Revision: 1.0
APPLIES TO
  • Microsoft Access 2.0 Standard Edition
Keywords: 
kb3rdparty kbbug kberrmsg KB123598
Retired KB Content Disclaimer
This article was written about products for which Microsoft no longer offers support. Therefore, this article is offered "as is" and will no longer be updated.

Give Feedback

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com