Select the product you need help with
- Internet Explorer
- Windows Phone
- More products
How to use dBASE data with Access and Jet
Article ID: 230125 - View products that this article applies to.
This article was previously published under Q230125
Novice: Requires knowledge of the user interface on single-user computers.
This article applies to a Microsoft Access database (.mdb)
The dBASE database driver works in one of the following two modes:
There may be incompatibilities with certain versions of the BDE. The symptoms of the incompatibilities vary, depending on the version of the BDE. Microsoft recommends version 5.01 of the Borland Database Engine. The following table lists the behavior that is supported for each of the dBASE file formats:
Collapse this tableExpand this table
To be able to write data to a linked dBASE file from within Access or from within a Jet 4.0 application, install the latest Jet 4.0 service pack or install the BDE.
The latest Jet 4.0 service packFor more information about how to obtain and install the latest Jet 4.0 service pack, click the following article number to view the article in the Microsoft Knowledge Base:
(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 licensing and run-time distribution requirements for the BDE from Inprise.
Third-party dBASE ODBC driver vendors include Merant (http://www.merant.com
(http://www.merant.com)), Borland.Com (http://www.borland.com
For information about how to contact your hardware vendor, visit the following Microsoft Web site:
http://support.microsoft.com/gp/vendorsFor more information about a hotfix, click the following article number to view the article in the Microsoft Knowledge Base:
(http://support.microsoft.com/kb/263561/ )Non-BDE Paradox and dBase ISAM drivers
For more information about using the dBASE Database driver, click Microsoft Access Help on the Help menu, type initializing the dbase database driver in the Office Assistant or the Answer Wizard, and then click Search to view the topic.
For more information about other drivers that use the latest Jet 4.0 service pack or the BDE in a similar way, click the following article number to view the article in the Microsoft Knowledge Base:
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/ )You cannot update a Paradox database in Access 2000 and other Jet Applications