MSQuery: Cannot Create Paradox Index

 Last reviewed: September 13, 1996
Article ID: Q113169
The information in this article applies to:
  • Microsoft Excel for Windows, version 5.0
  • Microsoft Excel for Windows 95, version 7.0
  • Microsoft Query for Windows, version 1.0
  • Microsoft Query for Windows 95, version 2.0

SUMMARY

When you save Microsoft Query table with unique indexes using Paradox as a data source, you may receive the following error messages:

  • Illegal index definition

    -or-

  • Paradox primary index name must match table name

MORE INFORMATION

Borland Paradox 3.5 only allows the primary key index to be created on the first column of the table. If you attempt to create an index on any field but the first, you will receive the following error message: 

   Illegal index definition
Unique indexes may be created on the first column using the table name as the index name. If you attempt to create an index with a name that does not exactly match the table name, you will receive the error message: 

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

REFERENCES

For more information about creating indexes, choose the Search button in Help and type: 

   indexes

KBCategory: kbusage kberrmsg kbtool
KBSubcategory: xlquery xlwin

Additional reference words: 5.00 7.00 1.00 Query



THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.

Last reviewed: September 13, 1996
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.