I'm using BDE 5.10 with Borland C++ Builder version 3.0 to connect to an Access 97 back end. When I connect with the native driver included with the BDE, all of the fields in my tables get re-ordered alphabetically by field name. This is totally messing up some of my SQL statements (INSERTS mainly). It doesn't happen with the ODBC driver, but the ODBC driver is exponentially slower than the native driver.
Does anyone know why the BDE's native Access driver does this, and if there is a fix for it? I should note that viewing the tables through Access shows the fields to be in the correct order.