File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes JDBC and Relational Databases and the fly likes I need to break a .mde file into smaller files Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "I need to break a .mde file into smaller files" Watch "I need to break a .mde file into smaller files" New topic

I need to break a .mde file into smaller files

jenny brad
Ranch Hand

Joined: Jun 24, 2006
Posts: 30
I have a request to break down a .mde access db into smaller files. I don't have much clue how to read a .mde file and create new ones.

does anyone have similar situations before?

Thanks a lot!
Paul Clapham

Joined: Oct 14, 2005
Posts: 19973

Well... I googled MDE files to find out what they are. Looks to me like an MDE file is a compiled version of an Access database. One of their purposes is to secure the database from being changed by the user. It is not designed to be decompiled. But apparently you can download and buy tools that can "unlock" an MDE and even convert it back to an MDB.

So in my opinion, if you're looking for Java code to extract the components from an MDE file, it doesn't exist and you won't be able to write it.

However, if you only need to write SQL code to extract data from that database, you should certainly be able to do that with JDBC. Is that what you actually need to do? Your description doesn't sound like that, but maybe that's because you haven't been given a clear description of the task yourself.
I agree. Here's the link:
subject: I need to break a .mde file into smaller files
It's not a secret anymore!