ACC2000: Using Paradox Data with Access 2000 and Jet

ID: Q230126

The information in this article applies to:

Microsoft Access 2000
Microsoft Data Access Components versions 2.1, 2.1 SP1, 2.1 SP2, 2.5

Novice: Requires knowledge of the user interface on single-user computers.

This article applies to a Microsoft Access database (.mdb) and a Microsoft Access project (.adp).

SYMPTOMS

The Paradox database driver work in one of two modes, depending upon whether the Borland Database Engine (BDE) is installed. Paradox data is only updateable with the BDE. Without the BDE, Paradox data can be read, imported and exported, or linked to read-only.

There may be incompatibilities with certain versions of BDE. The symptoms of the incompatibilities vary, depending upon the version of the BDE. Version 5.01 of the Borland Database Engine is recommended. The following table lists the behavior supported for each of the Paradox file formats:

Version Behavior

Paradox 3, 4, 5 ISAM Only Import\Export\Link-Read Only

Paradox 3, 4, 5 ISAM w/BDE Import\Export\Link-Read Write

Paradox 7-8 No support provided

Version	Behavior
Paradox 3, 4, 5 ISAM Only	Import\Export\Link-Read Only
Paradox 3, 4, 5 ISAM w/BDE	Import\Export\Link-Read Write
Paradox 7-8	No support provided

RESOLUTION

Contact Inprise Inc. or a third-party vendor to obtain the BDE. Obtain the licensing and run-time distribution requirements for the BDE from Inprise.

Third-party Paradox ODBC driver vendors include Merant (http://www.merant.com), Borland.Com (http://www.borland.com), and Inprise Inc. (http://www.Inprise.com). For additional information about how to contact Merant, Borland.Com, or Inprise Inc., please see the following articles in the Microsoft Knowledge Base:

Q65416 Hardware and Software Third-Party Vendor Contact List, A-K

Q60781 Hardware and Software Third-Party Vendor Contact List, L-P

Q60782 Hardware and Software Third-Party Vendor Contact List, Q-Z

MORE INFORMATION

If the BDE is not installed:

Microsoft Access does not prompt for, use, or maintain Paradox indexes as in earlier versions of Microsoft Access. If the BDE is installed, Access uses and maintains the indexes via the BDE.

The Paradox ISAM places an exclusive lock upon opening Paradox files. This includes opening linked Paradox tables or Paradox tables opened via DAO.

Multi-user capability is no longer supported.

Concurrent ODBC connections to the same table, from the same computer, or from multiple computers, is no longer supported.

APPEND, UPDATE, and DELETE are no longer supported.

Bulk writing of data to Paradox tables when using the INSERT INTO ... SELECT ... FROM ... syntax remains supported; however the indexes are no longer maintained.

The Paradox ISAM only supports the 8.3 naming convention as in earlier version of Microsoft Access.

Paradox extensions are not supported via the Microsoft Paradox IISAM, regardless of whether a version of the BDE is installed that supports it.

REFERENCES

For more information about using Paradox data with Microsoft Access, click Microsoft Access Help on the Help menu, type "Initializing the Paradox Database Driver" in the Office Assistant or the Answer Wizard, and then click Search to view the topic.

For additional information about other drivers that use the BDE, please see the following article in the Microsoft Knowledge Base:

Q230125 ACC2000: Using dBASE Data with Access 2000 and Jet

The third-party products discussed here are manufactured by vendors independent of Microsoft; we make no warranty, implied or otherwise, regarding these products' performance or reliability.

Additional query words: prb


Keywords          : kb3rdparty kbdta IsmPdox 
Version           : WINDOWS:2.1,2.1 SP1,2.1 SP2,2.5,2000
Platform          : WINDOWS 
Issue type        : kbprb

Last Reviewed: July 16, 1999