#2 Support writing access 97 file format

Unnassigned
open
nobody
None
9
2015-03-02
2006-07-01
M.J. Soft
No

It would be interesting a backport to manage Jet 3
files.

Discussion

  • F. Gerbig

    F. Gerbig - 2010-04-01

    Hi,

    any news on this?
    I have to deal with many access databases in this format and it would really help me :-)

    Kind regards,
    Frank.

     
  • F. Gerbig

    F. Gerbig - 2010-04-15

    Hi,

    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?

    Kind regards,
    Frank.

     
  • James Ahlborn

    James Ahlborn - 2010-08-02

    as of the 1.2.1 release jackcess supports reading jet3 database files.

     
  • Danny Leshem

    Danny Leshem - 2010-08-03

    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):

    000100005374616E64617264204A65742044420000000000B56E03626009C255E9A96772403F009C7E9F90FF859A31C579BAED30BCDFCC9D63D9E9C79C46116A58F286FBEC375D449CFAC65E28E613B68A6054947B36F57FDFB177F41343CFAFB1333461795B92B57C2A05F17C99011B98FD124F4A946C3E60265F95F8D089248567C61F2744D2EECF65EDFF07C746A178160CEDE92D00000000000000000000

    (sorry, I can't seem to find a way to attach files)

     
  • James Ahlborn

    James Ahlborn - 2011-11-12

    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).

     
  • Comment has been marked as spam. 
    Undo

    You can see all pending comments posted by this user  here

    Anonymous - 2011-11-12

    jahlborn - thanks! Jackcess 1.2.5 indeed managed to open my files. Good job!

     
    Last edit: Anonymous 2014-07-02
  • James Ahlborn

    James Ahlborn - 2012-10-16
    • summary: Support access 97 file format --> Support writing access 97 file format
    • milestone: --> Next_Release_(example)
     
  • James Ahlborn

    James Ahlborn - 2013-11-15
    • Priority: 1 --> 9
     
  • KillerAll

    KillerAll - 2015-03-02

    Hi,

    How can I help to do this?

    Is there any documentation about Jet 3?

    Thanks

     

Log in to post a comment.

Get latest updates about Open Source Projects, Conferences and News.

Sign up for the SourceForge newsletter:





No, thanks