MSQuery: "Can't access table..." If Paradox Table Not Indexed

The information in this article applies to:

• Microsoft Query for Windows, version 1.0
• Microsoft Query for Windows 95, version 2.0

SYMPTOMS

In Microsoft Query, you may receive the following error message when you try to use a Paradox table

   Can't access table <table name>

CAUSE

When you use a Paradox table in Microsoft Query, the table must have an existing index. This index is stored in a file with a .PX extension and is usually located in the same directory as the Paradox table. The index has the same name as the table.

RESOLUTION

To correct this problem, use any of the following methods to create an index for the Paradox table.

Method 1: If the table already contains data, use Paradox to create an

          index for the table. See the documentation included with Paradox
          for more details on how to do this.

          Method 1 above is preferred over this method because Microsoft
          Query cannot create an index on a Paradox table if it already
          contains data. To use this method on an empty table, perform the
          following steps:

          a. On the File menu, click Table Definition.

          The Select Data Source dialog box is displayed.

          b. From the Available Data Sources list, choose your Paradox
             data source and click the Use button.

           The Select Table dialog box is displayed.

          c. Click the Index button.

          The Create Index dialog box is displayed.

          d. In the Index Name field, type the name of your table. (Do not
             include the .DB extension.)

          e. In the Index Fields drop-down list, select the field needed
             to create the index for the table. If multiple fields are
             needed to create the index, separate the field names with
             commas. Once you are finished, click Close.

          f. In the Select Table dialog box, click Close.

STATUS

This behavior is by design. Unlike Microsoft Access, Microsoft Query does not automatically create an index for a Paradox table.

REFERENCES

For more information about Indexing Fields, choose the Search button in Help and type:

   indexing fields