ODBC Error: "Can't Open Unkeyed Paradox Table" |
Q109094
The information in this article applies to:
-
Microsoft Word for Windows, version 6.0
SYMPTOMS
If you attach a Paradox table that does not contain a key field to your
Word for Windows document, the following Open Database Connectivity (ODBC)
error messages occur:
Can't open unkeyed Paradox table.
and then
Unable to open table: <TableName>.
Word then attaches the data source, and you can perform a print merge
operation, but you cannot set filters or perform sorting operations on the
data source.
CAUSE
In Paradox version 3.5, you can designate a field as the key field (this is
similar to the functionality of Microsoft Access). If no key field is
designated in your Paradox table, the above errors occur.
STATUS
Microsoft has confirmed this to be a problem in Word for Windows. We are
researching this problem and will post new information here in the
Microsoft Knowledge Base as it becomes available.
RESOLUTION
Open the database in Paradox version 3.5 and assign a key to one of the
fields in your table.
MORE INFORMATION
Key Fields
Key fields are used to identify records. While they are strictly optional,
a key gives you the following benefits:
- Prevents duplicate values in the key field.
- Keeps the table sorted according to the values in the field.
- Creates a primary index on that field, which can speed queries and other
operations.
You can change fields from keys to non-keys, or vice versa. The only
constraint is that all key fields must be grouped at the beginning of the
table in order of precedence. To change a non-key field to a key field,
move the field to the beginning of the table and add an asterisk (*) after
the field type. Conversely, to change a key field to a non-key field, move
it out of the key field area and erase the asterisk (*). If any existing
records have duplicate values in the new key fields, Paradox places them in
the temporary Keyviol table.
Keyed Table
If a table does not contain key fields, its records are kept and displayed
in the order in which they were originally entered. If the table contains
more than one key field, the records are sorted by the primary (first) key
field, then (if necessary) by the secondary (second) key field.
The Paradox products included here are manufactured by Borland, Inc.,
vendors independent of Microsoft; we make no warranty, implied or
otherwise, regarding these products' performance or reliability.
REFERENCES
"Paradox 3.5 User's Guide," pages 119 and 126
Additional query words:
6.0 ODBC Key MSQuery database third party word6 winword table b_waccess