ACC2002: Using Paradox Data with Access  2002  and Jet 

Q286246


 --------------------------------------------------------------------------------
 
The information in this article applies to:

Microsoft Access  2002  
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). 

For a Microsoft Access  2000  version of this article, see Q230126. 


SYMPTOMS
The Paradox database driver works in one of two modes. One mode is when either 
the Microsoft Jet  4 . 0  Service Pack  5  (SP5) or the Borland Database Engine (BDE) is 
installed. The other mode is when neither of these are installed. Paradox data is 
only updateable when Jet  4 . 0  SP5 or the BDE is installed. Without Jet  4 . 0  SP5 or 
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/Jet  4  SP5 Import\Export\Link-Read Write 
Paradox  3 ,  4 ,  5  ISAM w/BDE Import\Export\Link-Read Write 
Paradox  7 - 8  No support provided 




RESOLUTION
To be able to write data to a linked dbase file from within Access  2002  or a Jet  4 . 0  
application you can install either Jet  4 . 0  SP5 or the BDE. 

Jet  4 . 0  Service Pack  5 
For additional information about how to obtain and install Jet  4 . 0  SP5, click the 
article number below to view the article in the Microsoft Knowledge Base: 
Q282010 ACC2002: Updated Version of Microsoft Jet  4 . 0  Available in Download 
Center 
NOTE: If you choose to install Jet  4 . 0  SP5, the linked Paradox table must have a 
primary key to be updateable. 
Borland Database Engine
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 neither Jet  4 . 0  SP5 nor the BDE is installed:


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


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.

If the BDE is not installed:

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.


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 additional information about other drivers that use Jet  4 . 0  SP5 or the BDE in a 
similar way, click the article number below to view the article in the Microsoft 
Knowledge Base: 

Q290867 ACC2002: Using dBASE Data with Access  2002  and Jet 
The third-party products discussed in this article are manufactured by vendors 
independent of Microsoft; we make no warranty, implied or otherwise, regarding 
these products' performance or reliability.