aspose file tools*
The moose likes JDBC 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


Win a copy of Spring in Action this week in the Spring forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "I need to break a .mde file into smaller files" Watch "I need to break a .mde file into smaller files" New topic
Author

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
Bartender

Joined: Oct 14, 2005
Posts: 18662
    
    8

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: http://aspose.com/file-tools
 
subject: I need to break a .mde file into smaller files