Cannot open my old MsAccess 2003 DB .mdb with its .mda file

A pure Java JDBC driver for Microsoft Access database files

Brought to you by: jamadei

Cannot open my old MsAccess 2003 DB .mdb with its .mda file

Forum: Help

Creator: Paul Poule

Created: 2017-12-01

Updated: 2017-12-21

Paul Poule - 2017-12-01

Hi,
I'm not a MsAccess expert but all I know is that my database (.mdb) need its .mda to be opened (msaccess.exe xxxx.mdb /wrkgrp yyyy.mda).
I don't understand how to do it with Ucanaccess.
Can you explain to me ?
Thanks.

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

Paul Poule - 2017-12-12

Is my question idiot?

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

Marco Amadei - 2017-12-12

What do you see opening your database with the console.bat?

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

Paul Poule - 2017-12-15

com.healthmarketscience.jackcess.impl.UnsupportedCodecException: Decoding not supported. Please choose a CodecProvider which supports reading the current database encoding.
at com.healthmarketscience.jackcess.impl.DefaultCodecProvider$UnsupportedHandler.decodePage(DefaultCodecProvider.java:126)
at com.healthmarketscience.jackcess.impl.PageChannel.readPage(PageChannel.java:237)
at com.healthmarketscience.jackcess.impl.UsageMap.read(UsageMap.java:130)
at com.healthmarketscience.jackcess.impl.PageChannel.initialize(PageChannel.java:117)
at com.healthmarketscience.jackcess.impl.DatabaseImpl.<init>(DatabaseImpl.java:531)
at com.healthmarketscience.jackcess.impl.DatabaseImpl.open(DatabaseImpl.java:400)
at com.healthmarketscience.jackcess.DatabaseBuilder.open(DatabaseBuilder.java:252)
at com.healthmarketscience.jackcess.DatabaseBuilder.open(DatabaseBuilder.java:291)
at net.ucanaccess.console.Main.hasPassword(Main.java:69)
at net.ucanaccess.console.Main.main(Main.java:142)
Decoding not supported. Please choose a CodecProvider which supports reading the current database encoding.

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

Marco Amadei - 2017-12-17

Ok it's encrypted, did you do the encryption set-up in the real code?

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

Paul Poule - 2017-12-19

What do you mean by "encryption set-up" and "real code" ?

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

Gord Thompson - 2017-12-19

@Paul - Check out the description for jackcessOpener on

http://ucanaccess.sourceforge.net/site.html#examples

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

Paul Poule - 2017-12-20

In this example only one database (file) is targeted (the .mny in the example).
In my case, my database (.mdb) needs another file (.mda) to be opened (it seems that users/password are defined in this 2nd file .mda).
I can't understand how to customize the example to answer my usecase ?

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

Gord Thompson - 2017-12-21

If your .mdb file is simply configured for user-level security then you probably don't need the Workgroup Information file (which BTW is normally .mdw, not .mda; the .mda extension is used for something else). Simply add the Jackcess Encrypt dependencies to your project ...

jackcess-encrypt-2.1.4.jar
bcprov-jdk15on-1.52.jar

... then create your jackcessOpener class (exactly like in the example cited above) and modify your connection URL to use it. You probably won't even have to provide a password in your DriverManager.getConnection call.

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

Log in to post a comment.