#160 Corrupted .mdb file created

[Piotr Stawinski]

Hi,

I'm using Jackcess to create MS Access .mdb files with the format FileFormat.V2003. The files have no primary key but do include two simple indexes. Each file contains over 400,000 rows.
I've found that some of the generated files are corrupted: when I run "Compact and Repair" in MS Access, some rows disappear. In other cases, sorting fails with the error: "Not a valid bookmark."
The issue is reproducible but occurs without an obvious cause. Approximately 4% of the files I create are affected.
Is this a known issue? I can provide source code and a sample database, but the files are large and contain confidential data, so I would prefer not to share them publicly.

Thanks.
Piotr

[James Ahlborn]

definitely not an expected situation. the first couple of questions:
- are you using the latest version of jackcess?
- are you closing the Database instance after every use (ensuring that everything in memory is flushed to disk)?
- is anything else modifying the access db while it is being modified by jackcess? (jackcess does not support concurrent modification)

i'd love to see some sample code of how you are editing the files and if you like, you can send me a file directly to inspect.

[Piotr Stawinski]

Thank you. I've just sent you a private message.