Main   Products   Offshore Outsourcing   Customers   Partners   ContactUs  
JDBC Databases
  HXTT Access v5.2
  Buy Now
  HXTT Cobol v2.1
  HXTT DBF v5.2
  HXTT Excel v4.2
  HXTT Paradox v5.2
  HXTT Text(CSV) v5.2
  HXTT XML v1.2
Offshore Outsourcing
Oracle Data Import/Export
DB2 Data Import/Export
Sybase Data Import/Export
Free Resources
  Firewall Tunneling
  Search Indexing Robot
  Conditional Compilation
  Password Recovery for MS Access
  Password Recovery for Corel Paradox
  Checksum Tool for MD5
  Character Set Converter
  Pyramid - Poker of ZYH
Hongxin Technology & Trade Ltd. of Xiangtan City (abbr, HXTT)

Access indexing problem with special characters
Magnus Meurer
2008-06-24 04:34:34.0

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
Re:Access indexing problem with special characters
Magnus Meurer
2008-06-24 06:59:59.0
Additional information:

The error message in english is: "Search Key Was Not Found in Any Record"

There is a similar thread: which is unfortunately not solved.
Re:Re:Access indexing problem with special characters
HXTT Support
2008-06-24 19:38:36.0
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.
Re:Re:Re:Access indexing problem with special characters
Magnus Meurer
2008-06-24 23:18:42.0
I've send you an email to 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
Re:Re:Re:Re:Access indexing problem with special characters
HXTT Support
2008-06-25 18:58:58.0
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.
Re:Re:Re:Re:Re:Access indexing problem with special characters
Magnus Meurer
2008-06-27 01:44:34.0
Works fine now,

even without "REINDEX ALL ON ..."

Best regards,
magnus meurer
Re:Re:Re:Re:Re:Re:Access indexing problem with special characters
HXTT Support
2008-06-27 02:14:17.0
>even without "REINDEX ALL ON ..."
Just used to avoid wrong index infromation for prior inserted rows.

Search Key   Search by Last 50 Questions


Address: 9 Station Rd., Xiangtan City, Hunan Province, P.R. China
Postcode: 411100
Phone: (86)731-58225727
Fax: (86)731-58225727
Copyright © 1999-2011 Hongxin Technology & Trade Ltd. | All Rights Reserved. | Privacy | Legal | Sitemap