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
HXTTAccess driver:#Error in datas of a table in Access 2003 sp3
laurence
2008-07-24 01:12:13.0
I have a program that runs on a server AIX, which retrieves data from an Oracle database for insert into a database Access. The base Access is on another server citrix which is accessed via samba.

The treatment is to send about 15 000 lines of data into a table containing columns of text and boolean. Very often, but not systematically data are inaccessible "Bookmark invalid" in the table Access.

What can I do to solve this problem ?
Re:HXTTAccess driver:#Error in datas of a table in Access 2003 sp3
HXTT Support
2008-07-24 08:54:07.0
>but not systematically data are inaccessible "Bookmark invalid"
>in the table Access.
Whether that mdb file can be read normally by MS Access after copy to local host?
Re:Re:HXTTAccess driver:#Error in datas of a table in Access 2003 sp3
Laurence
2008-07-25 00:53:50.0
The database is locked, I have to fix it.
Do you think it does not work properly because samba ?
Re:Re:Re:HXTTAccess driver:#Error in datas of a table in Access 2003 sp3
HXTT Support
2008-07-25 07:38:52.0
>Do you think it does not work properly because samba ?
MS Access and HXTT Access cant do concurrent update on the same mdb file at the same time because they're using different lock mechanism.
Re:Re:Re:Re:HXTTAccess driver:#Error in datas of a table in Access 2003 sp3
Laurence
2008-07-25 07:53:20.0
My treatment runs in the morning at 5am when nobody uses.
It fills an empty table. At 8am an other treatment reads the data and then deletes all
Re:Re:Re:Re:Re:HXTTAccess driver:#Error in datas of a table in Access 2003 sp3
HXTT Support
2008-07-25 08:05:25.0
First, you shoulduse delayedClose=0 connection property.
delayedClose: Indicates the delayed seconds for close transaction. That option is used to avoid frequent close/open table operations for following sqls. You can use 0~120 seconds. Default: 3.
Secondly, you should remember to close your HXTT Access connection after you commit ted all inserted data.

>The database is locked, I have to fix it.
Then you should avoid a lock database.

After that, please check "Whether that mdb file can be read normally by MS Access after copy to local host?" BTW, please use the latest HXTT Access v3.1 package for test.




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