MSQuery Err Msg: "Cannot Define Primary" in Paradox Table

ID: Q111046

1.00 2.00 WINDOWS kbtool kberrmsg

The information in this article applies to:

SUMMARY

In Microsoft Query, when you create an index for an existing Paradox table, you may receive the following error message:

   Cannot define primary

CAUSE

This error message appears if the table you are creating an index for contains data. You cannot create a unique index for a Paradox table that contains data.

WORKAROUND

To create an index on a field in a Paradox table, do either of the following:

These steps will create a new table with the fields and data contained in the original Paradox table.

MORE INFORMATION

In Microsoft Query, when you create an index on a field in a Paradox table that does not contain any data, the name of the index you are creating must match the name of the table. Additionally, you can only create an index on the first field in the table. If you create an index on a field other than the first field in the table, you receive the following error message

   Illegal index definition

and the index is not created.

You cannot edit data in a Paradox table in Microsoft Query unless a primary key has been defined in the table. Because in Microsoft Query you cannot create an index on a field in a Paradox table that contains data, you must add a primary key to the table in Paradox in order to edit the data in the table in Microsoft Query. When you attempt to edit a table in Microsoft Query that does not have a primary key defined for one of the fields, you will receive the following error message

   Can't open unkeyed Paradox table.

   Unable to open table: TABLENAME.

where TABLENAME is the name of the table you are editing.

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

For more information about the Create Index Dialog Box, or the Table Definition Command (File Menu), choose the Search button in Help and type:

    indexing fields

KBCategory: kbtool kberrmsg KBSubcategory: xlquery

Additional reference words: 1.00 2.00 5.00 5.00c

Keywords          : xlquery 
Version           : 1.00 2.00
Platform          : WINDOWS

Last Reviewed: September 15, 1996