Jackcess / Bugs / #101 Unrecognized map type: 75

James Ahlborn - 2014-02-04

What version is the database? Also, is the database currently in use by a windows application when you are trying to open it? Also, can MS Access itself open the file?

Last edit: James Ahlborn 2014-02-04

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Thomas Seeling - 2014-02-04

The file I'm trying to read is an exclusive copy of the original.
I tried with mdb-tools too and they fail, because the first byte of the file is 1, is not 0.
I can provide the file to you for testing, but I'd prefer to upload it somewhere private, since it contains real names.
The file is created by a proprietary Windows application, not Access.

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

James Ahlborn - 2014-02-08

What version of access database is it? did you copy the file while the app was running, or while it was stopped? also, can MS Access open the file?

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

James Ahlborn - 2014-04-05

Any more feedback on this? any chance you could send me an example db?

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
- Thomas Seeling - 2014-04-07
  
  -----BEGIN PGP SIGNED MESSAGE-----
  Hash: SHA1
  
  Hallo,
  
  I have offered to send you the DB file, but I never received an answer.
  The file contains personal data so I'd like to send it to you directly
  and not attach it to the ticket system. Can you provide an email or do
  you want a download link for google drive?
  
  Any more feedback on this? any chance you could send me an example
  db?
  
  Tschau...Thomas
  
  "Do you wanna be a legend or a passing footprint on the sands of time?"
  -----BEGIN PGP SIGNATURE-----
  Version: GnuPG v2.0.14 (GNU/Linux)
  Comment: Using GnuPG with Thunderbird - http://www.enigmail.net/
  
  iQEcBAEBAgAGBQJTQl6MAAoJEJx3bdG4OOtNaLUH/3zsFhqW10AH/M1JsoNFNnmY
  q2QIw50/k26rDapPFJcCS+YPT4k5x89+FY4W2BuJeO5CiWKK3ARKjy3q6wNfBUsq
  /bSTeSJveHG4op4i4QX0l8hOudhOOfMOCUL3HZUxRwBN1MITZVDGcVfP/7eMudbA
  tMD6Msr0ISL2oaiUosqo584Sz6ehPYPULAHAN5q8nHV5eqlMfQdMWHoWTYeS23+v
  q0HLiymcJ7K8ZjJNzSPc49M8XYCBcj//AllOVvST6vw0HrH4A+XtG6RP5ANEND8H
  ckdDmx3m7QJy+fs+wnsLJt02hKaBXz1HUDBZ/OP+8/qII9yYs0vXZKResmL20gw=
  =qe3A
  -----END PGP SIGNATURE-----
  
  If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

James Ahlborn - 2014-04-07

You can send a google drive download link to my sourceforge email, thanks!

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
- Thomas Seeling - 2014-04-07
  
  -----BEGIN PGP SIGNED MESSAGE-----
  Hash: SHA1
  
  Hallo,
  
  the access link is sent as personal email
  
  thanks very much for your patience and efforts ;)
  
  this is a proprietary PIM database for a veterinarian, and it contains
  schedules and customer names. please keep it confidential. thanks again!
  
  Tschau...Thomas
  
  "Do you wanna be a legend or a passing footprint on the sands of time?"
  -----BEGIN PGP SIGNATURE-----
  Version: GnuPG v2.0.14 (GNU/Linux)
  Comment: Using GnuPG with Thunderbird - http://www.enigmail.net/
  
  iQEcBAEBAgAGBQJTQrD3AAoJEJx3bdG4OOtNnmQH/2MHUE0/6VjraxFTQPacznbF
  q231Z9LLhgw0N/y+HTbOq1EiR07gZeuhiDByNZMEVf0OXECsb9ErW/sMUa7xA95W
  hfubTFMrGPyyJ9Fwnw7xJgcjNEqLTqHQ9C6O6gjGslq8NgoW/fjlpt40cziH6xOY
  PE1queUzuu2zjjbAZjxHDr5ypjjKlBGKsLmAszIAXpOK7p6DBYrNIC3jnT7ayl6N
  fBxeJBpyYw5WdFKNy2FwJYwG7BNwkOV8qCV25XQPDNVgFhY4dV6bY8tHDf0gtj9N
  aaMH3k1NpLeiXUKmAhcUNBKHsJBJ60j8kJoYURSpTgh2AIl/kzlOTbyIlhUdrYM=
  =ZadB
  -----END PGP SIGNATURE-----
  
  Last edit: Thomas Seeling 2014-04-07
  
  If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
  - James Ahlborn - 2014-04-08
    
    i don't seem to have permission to download the file.
    
    If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
  - James Ahlborn - 2014-04-08
    
    well, i have successfully downloaded your file, thanks.
    
    However, i can't open the file with microsoft access. if access refuses to open the file, then the problem is probably with the file.
    
    If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Brian Turner - 2014-04-07

I have a similar error:

Caught: java.io.IOException: Unrecognized map type: 75
java.io.IOException: Unrecognized map type: 75
at com.healthmarketscience.jackcess.impl.UsageMap.initHandler(UsageMap.java:163)
at com.healthmarketscience.jackcess.impl.UsageMap.read(UsageMap.java:151)
at com.healthmarketscience.jackcess.impl.PageChannel.initialize(PageChannel.java:132)
at com.healthmarketscience.jackcess.impl.DatabaseImpl.<init>(DatabaseImpl.java:515)</init>

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
- James Ahlborn - 2014-04-08
  
  do you have an example database you can provide?
  
  If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
  - Brian Turner - 2014-04-08
    
    Unfortunately it contains patient information, and cannot be shared.
    However I suspect the problem lies with the fact it's a very old version of
    access (like 1.0). I can't open the file access2010, so it doesn't look
    good.
    
    B.
    
    On Tue, Apr 8, 2014 at 8:07 AM, James Ahlborn jahlborn@users.sf.net wrote:
    
    do you have an example database you can provide?
    
    [bugs:#101] http://sourceforge.net/p/jackcess/bugs/101/ Unrecognized
    map type: 75*
    
    Status: open
    Group: Unassigned
    Created: Mon Feb 03, 2014 06:20 PM UTC by Thomas Seeling
    Last Updated: Mon Apr 07, 2014 05:12 PM UTC
    Owner: nobody
    
    Hallo,
    
    I have a JET database for a proprietary Windows application. It contains
    schedules, dates, appointments, reminders, etc., in short, a PIM.
    I want to read this file regularly (cron job on my linux server) and
    update a web calendar with new entries from that JET database.
    The database is not encrypted, I can open without password, but it
    contains german umlauts. With strings I see the plain text of records
    within.
    Using 2.0.3 with current BC release.
    
    $ java mdb
    Reading VETERA07.MDB
    java.io.IOException: Unrecognized map type: 75
    at
    com.healthmarketscience.jackcess.impl.UsageMap.initHandler(UsageMap.java:163)
    at com.healthmarketscience.jackcess.impl.UsageMap.read(UsageMap.java:151)
    at
    com.healthmarketscience.jackcess.impl.PageChannel.initialize(PageChannel.java:132)
    at
    com.healthmarketscience.jackcess.impl.DatabaseImpl.(DatabaseImpl.java:511)
    at
    com.healthmarketscience.jackcess.impl.DatabaseImpl.open(DatabaseImpl.java:386)
    at
    com.healthmarketscience.jackcess.DatabaseBuilder.open(DatabaseBuilder.java:170)
    at mdb.main(mdb.java:22)
    Finished VETERA07.MDB
    
    Sent from sourceforge.net because you indicated interest in
    https://sourceforge.net/p/jackcess/bugs/101/
    
    To unsubscribe from further messages, please visit
    https://sourceforge.net/auth/subscriptions/
    
    Related
    
    Bugs: ~~#101~~
    
    alternate
    
    If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
    - James Ahlborn - 2014-04-08
      
      jackcess can handle versions back to 97, but if it's earlier than that, it's probably not going to work, sorry. My benchmark is pretty much that if MS access refuses to open it, then jackcess probably won't handle it.
      
      If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
      - Brian Turner - 2014-04-08
        
        OK. Thanks for following up.
        
        B.
        
        On Tue, Apr 8, 2014 at 10:02 AM, James Ahlborn jahlborn@users.sf.netwrote:
        
        jackcess can handle versions back to 97, but if it's earlier than that,
        it's probably not going to work, sorry. My benchmark is pretty much that if
        MS access refuses to open it, then jackcess probably won't handle it.
        
        [bugs:#101] http://sourceforge.net/p/jackcess/bugs/101/ Unrecognized
        map type: 75*
        
        Status: open
        Group: Unassigned
        Created: Mon Feb 03, 2014 06:20 PM UTC by Thomas Seeling
        Last Updated: Mon Apr 07, 2014 05:12 PM UTC
        Owner: nobody
        
        Hallo,
        
        I have a JET database for a proprietary Windows application. It contains
        schedules, dates, appointments, reminders, etc., in short, a PIM.
        I want to read this file regularly (cron job on my linux server) and
        update a web calendar with new entries from that JET database.
        The database is not encrypted, I can open without password, but it
        contains german umlauts. With strings I see the plain text of records
        within.
        Using 2.0.3 with current BC release.
        
        $ java mdb
        Reading VETERA07.MDB
        java.io.IOException: Unrecognized map type: 75
        at
        com.healthmarketscience.jackcess.impl.UsageMap.initHandler(UsageMap.java:163)
        at com.healthmarketscience.jackcess.impl.UsageMap.read(UsageMap.java:151)
        at
        com.healthmarketscience.jackcess.impl.PageChannel.initialize(PageChannel.java:132)
        at
        com.healthmarketscience.jackcess.impl.DatabaseImpl.(DatabaseImpl.java:511)
        at
        com.healthmarketscience.jackcess.impl.DatabaseImpl.open(DatabaseImpl.java:386)
        at
        com.healthmarketscience.jackcess.DatabaseBuilder.open(DatabaseBuilder.java:170)
        at mdb.main(mdb.java:22)
        Finished VETERA07.MDB
        
        Sent from sourceforge.net because you indicated interest in
        https://sourceforge.net/p/jackcess/bugs/101/
        
        To unsubscribe from further messages, please visit
        https://sourceforge.net/auth/subscriptions/
        
        Related
        
        Bugs: ~~#101~~
        
        alternate
        
        If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
      - Thomas Seeling - 2014-04-09
        
        -----BEGIN PGP SIGNED MESSAGE-----
        Hash: SHA1
        
        Hallo,
        
        On 04/08/2014 04:02 PM, James Ahlborn wrote:
        
        jackcess can handle versions back to 97, but if it's earlier than
        that, it's probably not going to work, sorry. My benchmark is
        pretty much that if MS access refuses to open it, then jackcess
        probably won't handle it.
        
        I was afraid to hear this.
        Nevertheless thanks very much for your efforts in trying it ;)
        Do you happen to know any other tool to make the file readable?
        
        Tschau...Thomas
        
        "Do you wanna be a legend or a passing footprint on the sands of time?"
        -----BEGIN PGP SIGNATURE-----
        Version: GnuPG v2.0.14 (GNU/Linux)
        Comment: Using GnuPG with Thunderbird - http://www.enigmail.net/
        
        iQEcBAEBAgAGBQJTRPp/AAoJEJx3bdG4OOtNPzgIAI7LHV2TcFjsIaQILAQbf55f
        4MRpTD81okCp8zn3GzVBMPEcyo+ju8w9DpEnBLYRkfXBkuhyDdLRVkfcwNRTXVVz
        UMRgG7i52LJ3vzm7sc1zBQTm78zYIke5ujVjlNgk0TNVyaXaKSKBx5+xxveH8O1W
        4tmT7UIKghZQME0OsJLdC+FeIwqCoWAjuM5YgTuxB5vMMW4kQD/zOiDjZd2DeQe+
        vXjWho98FuHIKCNO9ZCF4F1yFHDMeH42tOgJOHGQG8BOeEwms+YF/j82EeJc1Bpo
        J9gxjJs4sdkkdQI8OsJSATX06X+WQVqHnk2S3EF3GZ5kjq5lKE3MM1kRXRRQNOs=
        =kfOI
        -----END PGP SIGNATURE-----
        
        If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

James Ahlborn - 2014-04-09

status: open --> wont-fix
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

James Ahlborn - 2014-04-09

Closing this issue as the databases in question are not valid access databases (at least not version 97 or newer).

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Unrecognized map type: 75

Group

Searches

Help

#101 Unrecognized map type: 75

Related

Discussion

do you have an example database you can provide?

Related

Related