I'm using an ODBC driver created by SmartWare Corporation in my VB.net program. The driver has some association with faircomm though I'm not certain what that association is. Unfortunately SmartWare Corporation is no longer in business and support is limited to other users. So far I've been unable to solve the problem I'm facing and I'm hoping that someone may recognize these symptoms from another ODBC driver or from their experience with ODBC in general and have some insight.
If I edit an existing record (call it #1) and save it and then insert a new record (call it #2), record #2 is inserted as expected and the contents of record #1 are overwritten with the contents of record #2.
At this point if the database file is opened in the main software, any changes to either record also affect the other record. If record #1 is deleted, so is record #2 and vice-versa.
Anyone ever experienced similar behavior using ODBC drivers? Any ideas where I might garner more clues.