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
Sorting by a column in Microsoft Access could result in empty Table Overview
Norbert
2006-02-23 00:00:00.0
To check the database, we open the mdb file under Windows with Microsoft Access. We filled the mdb file by usage of the HXTT Access JDBC driver (the download from 22th february 2006). When opening a table overview for one of the tables, everything seems to be OK. But when trying to sort columns (e.g. right mouse on the header of a column and select 'Descending') it could happen that all records in the active view seems to get lost.

Actually the data records are not lost, it is possible to open the table view again. But it is not possible to sort by this column in the new view, either.

Only a few columns behave like this. Most of the columns allow sorting!

If this error occured for a column, then it is reproducable for this column (even when restarting Microsoft Access). But it could also happen that another mdb file - filled with the same peace of code - doesn't show this problem.

After running 'Database compress and repair' it is possible to sort the columns that showed this problem. But opening every exported file in Microsoft Access and 'repair' it is no solution.

Do you know what is going wrong here? Any idea on this?

Thanks,
Norbert
Re:Sorting by a column in Microsoft Access could result in empty Table Overview
HXTT Support
2006-02-24 00:00:00.0
We haven't recurred "all records in the active view seems to get lost" still, but have recurred "part records in the active view seems to get lost" by 'Descending' sort columns. You should are using JET4(MS Access 2000, 2003, XP, and so on), and that column should be an indexed text column. We're digging out to find why there's minor incompatibility, and that issue should be resolved in 48 hours. Thanks for you patience.
Re:Re:Sorting by a column in Microsoft Access could result in empty Table Overview
HXTT Support
2006-02-26 00:00:00.0
Supported now. Please download the latest package.
Re:Re:Re:Sorting by a column in Microsoft Access could result in empty Table Overview
Norbert
2006-02-27 00:00:00.0
I did some tests and couldn't reproduce the problem anymore. Seems to be solved.
Thank you for your quick help!

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