Main   Products   Offshore Outsourcing   Customers   Partners   ContactUs  
JDBC Databases
  HXTT Access v5.2
 
  Buy Now
  Support
  Download
  Document
  FAQ
  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)

HXTT ACCESS
Corrupts MDB: The search key was not found in any record
Greg Jungman
2006-03-28 00:00:00.0
I'm very interested in buying your product, but:

I'm using PreparedStatement.executeBatch(); this works fine on the JDBC-ODBC bridge that ships with Java. But, when I use your software, I open the MS-Access DB after I run my inserts and try to delete a record and get the following error: "The search key was not found in any record"
Re:Corrupts MDB: The search key was not found in any record
HXTT Support
2006-03-28 00:00:00.0
What's your sql? Have you built some index on your MDB file? If possible, you can send your mdb sample to webmaster.hxtt@gmail.com .
Re:Re:Corrupts MDB: The search key was not found in any record
Greg Jungman
2006-03-29 00:00:00.0
The table has a primary key index. The SQL on this table in my test script that causes the error is:

PreparedStatement insertCollection = con1
.prepareStatement("INSERT INTO UI_COLLECTIONS (PK_OBJECT_ID, PK_COLLECTION_KEY, COLLECTION_VALUE, KEY_TYPE, VALUE_TYPE, PK_VERSION_ID, USER_CODE, LAST_USED_DATE) "
+ "VALUES (?,?,?,?,?,?,?,?)");

PreparedStatement updateCollection = con1
.prepareStatement("UPDATE UI_COLLECTIONS SET COLLECTION_VALUE = ?, VALUE_TYPE = ?, USER_CODE = ?, LAST_USED_DATE = ? WHERE PK_OBJECT_ID = ? AND PK_COLLECTION_KEY = ? AND PK_VERSION_ID = ?");


Where the columns prefixed by "PK_" are primary keys, and thus form an index.

I could send you an MDB but it's very large.
Re:Re:Re:Corrupts MDB: The search key was not found in any record
HXTT Support
2006-03-29 00:00:00.0
You can copy your mdb file to temp.mdb file, then remove all tables except for that UI_COLLECTIONS talbe, then delete all rows in UI_COLLECTIONS. Then run Compact/Repair database in Ms Access, then email that mdb file with empty table structure and index information. Then we will produce simulation data to recur your issue. Thanks.

Search Key   Search by Last 50 Questions




Google
 

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