Article ID: 230126 - View products that this article applies to.
This article was previously published under Q230126
Novice: Requires knowledge of the user interface on single-user computers.
This article applies to a Microsoft Access database (.mdb) and to a Microsoft Access project (.adp).
The Paradox database driver works in one of two modes. One mode is when either of the following are installed:
Note Paradox data is only updateable when Jet 4.0 SP5 or a later version or the BDE is installed. Without Jet 4.0 SP5 or a later version or the BDE, Paradox data can be read, imported and exported, or linked to as read-only.
There may be incompatibilities with certain versions of the BDE. The symptoms of the incompatibilities vary. The symptoms depend on the version of the BDE. The BDE version 5.01 is recommended. The following table lists the behavior that is supported for each Paradox file format:
Collapse this tableExpand this table
To be able to write data to a linked dBASE file from Access or from a Jet 4.0 application, you can install either the latest Jet 4.0 service pack or the BDE. We recommend that you install the latest Jet 4.0 service pack. If you install the latest Jet 4.0 service pack and continue not to be able to use Paradox data with Access, install the BDE.
Install the latest Jet 4.0 service packFor additional information about how to obtain the latest Jet 4.0 service pack, click the following article number to view the article in the Microsoft Knowledge Base:
239114Note If you want to install the latest Jet 4.0 service pack, the linked Paradox table must have a primary key to be updateable.
(http://support.microsoft.com/kb/239114/ )How to obtain the latest service pack for the Microsoft Jet 4.0 Database Engine
Borland Database EngineContact Inprise, Inc. or a third-party vendor to obtain the BDE. Obtain the licensing and the run-time distribution requirements for the BDE from Inprise, Inc.
For additional information about third-party Paradox ODBC driver vendors, visit the following Web site:
http://www.borland.comFor more information about hardware and software vendor contact information, visit the following Microsoft Web site: http://support.microsoft.com/gp/vendors
For additional information about other drivers that use Jet 4.0 Service Pack 5 or a later version or the BDE in a similar way, click the following article number to view the article in the Microsoft Knowledge Base:
230125For additional information about a required primary key on all tables with multiuser functionality, click the following article number to view the article in the Microsoft Knowledge Base:
(http://support.microsoft.com/kb/230125/ )How to use dBASE data with Access 2000 and Jet
209795For additional information, click the following article number to view the article in the Microsoft Knowledge Base:
(http://support.microsoft.com/kb/209795/ )Error occurs when you try to use multiple instances of a linked Paradox table
230126The third-party products that this article discusses are manufactured by companies that are independent of Microsoft. Microsoft makes no warranty, implied or otherwise, regarding the performance or reliability of these products.
(http://support.microsoft.com/kb/230126/ )How to use Paradox data with Access and Jet
Article ID: 230126 - Last Review: November 12, 2004 - Revision: 4.3