ID: Q141285
1.00 2.00 WINDOWS kbtool kb3rdparty kberrmsg
The information in this article applies to:
In Microsoft Query, you may receive the following error message when you try to use a Paradox table
Can't access table <table name>
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.
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.
This behavior is by design. Unlike Microsoft Access, Microsoft Query does not automatically create an index for a Paradox table.
For more information about Indexing Fields, choose the Search button in Help and type:
indexing fields
Additional reference words: 1.00 2.00 ODBC 3.0 3.00 4.0 4.00 5.0 5.00 5.00c 7.00
Keywords : xlquery
Version : 1.00 2.00
Platform : WINDOWSLast Reviewed: March 30, 1997