We are insert records in an Access Database throught the HXTT Access driver that is also written and read by an VB application using the JET engine. If there is an relationship on the table, the table index will be broken after a write. If the relationship is removed, the JET engine doesn't "see" the written records although looking with an other tool (unclear which tool this is), reveals that the records have been written.
Is this a known problem and what is the solution? Are there properties or settings for the HXTT driver OR for the Jet Engine to solve these problems?
>Is this a known problem and what is the solution?
HXTT Access can't do concurrent write/read operation with MS Access since they're using different lock mechanism. You can use jdbc-odbc bridge driver.