Microsoft KB Archive/238431

= PRB: dBase Driver Cannot Update DBF Files in MDAC 2.1 and Later Versions =

Article ID: 238431

Article Last Modified on 12/31/2005

-

APPLIES TO


 * Microsoft Data Access Components 2.1
 * Microsoft Data Access Components 2.1 Service Pack 2
 * Microsoft Data Access Components 2.1 Service Pack 1
 * Microsoft Data Access Components 2.1 Service Pack 2
 * Microsoft Data Access Components 2.5

-



This article was previously published under Q238431



SYMPTOMS
You may encounter a variety of ODBC error messages when accessing dBase databases which had been successfully accessible with prior versions of the Microsoft dBase Driver.



CAUSE
Versions of MDAC 2.1 and later require the Borland Database Engine (BDE) to update dBase DBF files.



RESOLUTION
There are two resolutions. One is to obtain the BDE:

Contact 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), 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:

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

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

60782 Hardware and Software Third-Party Vendor Contact List

The other option is to use the Microsoft FoxPro VFP Driver that ships with MDAC 2.1 to access the DBF files. To use this driver to access dBase files, select the Free Table Directory option when creating a DSN.



STATUS
This behavior is by design.

