Hi,
we are using Access JDBC 3.0 Package (release date: 2008-06-10 07:50) and received the following problem:
When writing data into an MDB-File using INSERT or UPDATE-Statements, having geman umlaut characters like ö,ä,�� or chars like ��, ��, ... as field values, we end up having a corrupt access file. The data is written into the table, but some operations like deleting the newly inserted row via Access frontend will produce a error message (Error message in german: "Der Suchschl��ssel wurde in keinem Datensatz gefunden")
Note: This problem only occurs if the above mentioned characters are written into indexed table columns. Writing them into non-indexed columns is problem-free.
Executing "REINDEX ALL ..." on the modified table won't fix the problem.
Reparing the MDB file using the access frontend works fine. After that, you can once again delete the inserted row(s).
Any suggestions?
Best regards,
Magnus Meurer
|
Additional information:
The error message in english is: "Search Key Was Not Found in Any Record"
There is a similar thread: http://www.hxtt.com/support/access1143568504.html which is unfortunately not solved.
|
|
What's your Access version and sort order for index? Because MS Access use different index order for local charset, HXTT Access has to simulate those actions, and has supported more than 18 kinds of sort order. You can email us such an empty mdb file than we will check those information.
|
I've send you an email to support@hxtt.com with the requested mdb file.
The file is an Access 2000 file format.
Note: Since the mdb-File is part of a third party product, we are not able to change the index structure of the database.
Best regards,
magnus meurer
|
|
Thanks. Supported. Please download the latest package after about 24 hours. Then try "REINDEX ALL on addresses", if your issue disappear by testing , that's OK.
|
Works fine now,
even without "REINDEX ALL ON ..."
Best regards,
magnus meurer
|
>even without "REINDEX ALL ON ..."
Just used to avoid wrong index infromation for prior inserted rows.
|
Main
webmaster@hxtt.com