String fields appear doubled to the IDE when connecting to Access tables via ODBC

By: Vincent Drake

Abstract: A change in Access ODBC drivers is accounted for in BDE 5.1.1

Problem:

When working with Access tables using ODBC drivers, the BDE reports error messages concerning string field sizes. The Delphi/C++Builder IDE sees the fields as twice the size they are in the database and reports errors.

Solution:

Update to the latest version of the BDE here.

Explanation:

A recent change in the behavior of the Access ODBC drivers was not accounted for in older versions of the BDE. The details of this problem can be found on the Borland Community Site. The BDE has since been updated to resolve this problem.


Server Response from: ETNASC01