Works: Field Names Are Lost or Truncated When You Save File as dBase

Retired KB Content Disclaimer

View products that this article applies to.

This article was previously published under Q243313

Expand all | Collapse all

SYMPTOMS

When you save a Microsoft Works database file in dBASE III or dBASE IV format, the following changes occur:

Field names longer than 10 characters are truncated.
If the first 10 characters of 2 or more field names are identical, some field names are lost.
If the dBASE file is opened again in Works, some fields that are displayed in Form view are not visible in List view.

Back to the top

CAUSE

This behavior occurs because of limitations in the dBASE file format.

Back to the top

STATUS

Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.

Back to the top

MORE INFORMATION

The following example illustrates typical field names from a Works database:

Name:
Company:
Address Line 1:
Address Line 2:
City:
State:
Zip:

If you save the database in a dBASE III or dBASE IV file format, and then open the dBASE file again in Works, the field names are displayed as follows in Form view:

NAME:
COMPANY:
ADDRESS_LI:
FIELD 4:
FIELD 5:
FIELD 6:
FIELD 7:

Because the first 10 characters of the fields "Address Line 1" and "Address Line 2" are the same, all fields after the "Address Line 1" field are changed to a generic field name.

If you switch to the List view in Works, you see only the following three fields, and you are unable to gain access to any of the data in the missing fields while in List view:

   NAME:     COMPANY:      ADDRESS_LI:

To gain access too the data again in List view, save the dBASE file in one of the following formats, and then open the file in Works:

Works database
Text and commas
Text and tabs

Back to the top

APPLIES TO

Microsoft Works Suite 2000
Microsoft Works Suite 2001
Microsoft Works 6.0
Microsoft Works 2000 Standard Edition

Back to the top

kbbug kbpending KB243313

Back to the top

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.

Back to the top