Main   Products   Offshore Outsourcing   Customers   Partners   ContactUs  
JDBC Databases
  HXTT Access 7.1.111
 
  Buy Now
  Support
  Download
  Document
  FAQ
  HXTT Cobol 5.0.111
  HXTT DBF 7.1.112
  HXTT Excel 6.1.115
  HXTT Json 1.0.083
  HXTT Paradox 7.1.111
  HXTT PDF 2.0.111
  HXTT Text(CSV) 7.1.111
  HXTT Word 1.1.111
  HXTT XML 4.0.112
Offshore Outsourcing
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
   
   
   
Heng Xing Tian Tai Lab of Xi'an City (abbr, HXTT)

HXTT ACCESS
MSB CORRUPTED OR DAMAGED
Rudi Mazzaro
2019-09-18 01:51:58.0
Hy

after some tests I hav a problem.
After writing data on a table I cannot execute queries.
The table name is bolrighe.

This query works "SELECT * from bolrighe where copia = 1"
This query works "SELECT * from bolrighe where copia = 1 and COMPOCODKEY<>''"
This query doesnt work "SELECT * from bolrighe where copia = 1 and COMPOCODKEY<>'' and numbolla = 27052"

I don't know why.
Maybe I can send to you the MDB files ? is Yes how cna I send to you the MDB ?

Thks




Hy
Re:MSB CORRUPTED OR DAMAGED
HXTT Support
2019-09-18 02:51:51.0
What's your error message?

You can send support @ hxtt.com your sample.
Re:Re:MSB CORRUPTED OR DAMAGED
Rudi Mazzaro
2019-09-18 03:02:04.0
Message error is in Italian.
I translate for you.
"Impossible to open database ''. It's possible that database is not recognized for application or file is damaged".
Of cours this in ACCESS.
I send to you the zip file.
Thks
Re:Re:Re:MSB CORRUPTED OR DAMAGED
HXTT Support
2019-09-18 04:14:58.0
After run once
reindex all on bolrighe;

your issue should disappear.

So that should be an index issue.

What did program insert those records? Whether haven't you used lockType=ACCESS connection property?

Re:Re:Re:Re:MSB CORRUPTED OR DAMAGED
Rudi Mazzaro
2019-09-18 05:04:09.0
Hy

this is the connection URL we use
jdbc:access:///c:\\dati\\pictures.mdb?delayedClose=0;lockType=ACCESS .

We use IsCobol that is an Cobol that support Java. This means that Cobol Source Code can use Java libraries and then when compiled it creates a Java file and then a JAVACLASS.

IN any case I send to you the LOG FILE when I run the program as you can see how we add data to the BOLRIGHE table.

Problem happens when I write a lot of data...and not always!
Hy
Re:Re:Re:Re:Re:MSB CORRUPTED OR DAMAGED
HXTT Support
2019-09-18 08:21:16.0
2019-09-18 fix a seldom index format compatible bug for level information of root node when it downgrade from index node to leaf node. It does not influence data, but MS Access will think it's incorrect.

Please redownload it.
Re:Re:Re:Re:Re:Re:MSB CORRUPTED OR DAMAGED
Rudi Mazzaro
2019-09-18 08:23:03.0
OK thks!

Search Key   Search by Last 50 Questions




Google
 

Email: webmaster@hxtt.com
Copyright © 2003-2019 Heng Xing Tian Tai Lab of Xi'an City. | All Rights Reserved. | Privacy | Legal | Sitemap