ACC1x: MS Access Cannot Attach or Import Paradox 4.0 Tables

• Microsoft Access versions 1.0, 1.1

SUMMARY

Microsoft Access supports attaching and importing from Paradox 3.x tables. Microsoft Access does not support attaching Paradox 4.0 tables. If you attempt to attach a version 4.0 table, you will be prompted for a password. This also applies to Paradox 1.0 for Windows files.

MORE INFORMATION

If you are prompted to enter a password when you attach to a Paradox table, and you know that there is no password for the table, it is possible the table is a Paradox 4.0 file.

NOTE: These directions apply to Paradox 4.0 only; these directions do not apply to Paradox for Windows.

To use data created in Paradox 4.0, use Paradox to restructure the table in version 3.5 format. Paradox provides the capability to create files in Compatible format; this will create files in version 3.5 format.

In Paradox, you can save a Paradox 4.0 table in version 3.5 format by following these steps:

1. Copy the Paradox 4.0 table.

2. In Paradox, run the Modify/Restructure menu command.

3. Enter the name of the table.

4. Choose FileFormat/Compatible from the menu.

5. Press F2 to save the file in the restructured format.