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

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.