It would be interesting a backport to manage Jet 3
any news on this?
I have to deal with many access databases in this format and it would really help me :-)
in mdbtools-java I found the following:
MdbJet3Constants.pg_size = 2048;
MdbJet3Constants.row_count_offset = 0x08;
MdbJet3Constants.tab_num_rows_offset = 12;
MdbJet3Constants.tab_num_cols_offset = 25;
MdbJet3Constants.tab_num_idxs_offset = 27;
MdbJet3Constants.tab_num_ridxs_offset = 31;
MdbJet3Constants.tab_usage_map_offset = 35;
MdbJet3Constants.tab_first_dpg_offset = 36;
MdbJet3Constants.tab_cols_start_offset = 43;
MdbJet3Constants.tab_ridx_entry_size = 8;
MdbJet3Constants.col_fixed_offset = 13;
MdbJet3Constants.col_size_offset = 16;
MdbJet3Constants.col_num_offset = 1;
MdbJet3Constants.tab_col_entry_size = 18;
MdbJet4Constants.pg_size = 4096;
MdbJet4Constants.row_count_offset = 0x0c;
MdbJet4Constants.tab_num_rows_offset = 12;
MdbJet4Constants.tab_num_cols_offset = 45;
MdbJet4Constants.tab_num_idxs_offset = 47;
MdbJet4Constants.tab_num_ridxs_offset = 51;
MdbJet4Constants.tab_usage_map_offset = 55;
MdbJet4Constants.tab_first_dpg_offset = 56;
MdbJet4Constants.tab_cols_start_offset = 63;
MdbJet4Constants.tab_ridx_entry_size = 12;
MdbJet4Constants.col_fixed_offset = 15;
MdbJet4Constants.col_size_offset = 23;
MdbJet4Constants.col_num_offset = 5;
MdbJet4Constants.tab_col_entry_size = 25;
Perhaps this helps?
as of the 1.2.1 release jackcess supports reading jet3 database files.
Thanks! This is an extremely useful addition.
I've been trying it on some JET3 mdb files, with varying results. Following are the first 160 bytes (in hex format) of an MDB file that didn't work (threw java.lang.IndexOutOfBoundsException):
(sorry, I can't seem to find a way to attach files)
dleshem - sorry, i somehow missed your comment. you can attach a file by scrolling to the bottom of this screen and clicking on the "Attached File" section. or, better yet, you could file a separate bug and attach your problem database there. (note, there have been some fixes, so you should try the latest jackcess version first).
jahlborn - thanks! Jackcess 1.2.5 indeed managed to open my files. Good job!
You seem to have CSS turned off.
Please don't fill out this field.
How can I help to do this?
Is there any documentation about Jet 3?
This is the closest thing to documentation of the file format:
Log in to post a comment.
Sign up for the SourceForge newsletter: