'Microsoft Access Database' with Java.

Thread view:

Fabian Rossbacher - 27 May 2004 14:58 GMT

Hi,
is there any way to get the data of a 'Microsoft-Access-Database' with Java
under Linux?I have got only the .mbd file and no Windows...

greez fabian

Reply to this Message

Chris Smith - 27 May 2004 17:05 GMT

> is there any way to get the data of a 'Microsoft-Access-Database' with Java
> under Linux?I have got only the .mbd file and no Windows...

No, JDBC isn't magic. If you want to use a database, you'll need DBMS
software to do it. No one is likely to rewrite all of the core
functionality of Microsoft Access in a JDBC driver any time soon.

Signature

www.designacourse.com
The Easiest Way to Train Anyone... Anywhere.

Chris Smith - Lead Software Developer/Technical Trainer
MindIQ Corporation

Reply to this Message

Luke Webber - 28 May 2004 00:09 GMT

> > is there any way to get the data of a 'Microsoft-Access-Database' with Java
> > under Linux?I have got only the .mbd file and no Windows...
>
> No, JDBC isn't magic. If you want to use a database, you'll need DBMS
> software to do it. No one is likely to rewrite all of the core
> functionality of Microsoft Access in a JDBC driver any time soon.

Nope. Your best bet is to convert the database in a Winblows machine, using
a JDBC connection to a Linux-hosted server DBMS as your target.

Luke

Reply to this Message

Martin Schmid - 01 Jun 2004 13:00 GMT

> "Chris Smith" <cdsmith@twu.net> wrote
>
[quoted text clipped - 7 lines]
> Nope. Your best bet is to convert the database in a Winblows machine, using
> a JDBC connection to a Linux-hosted server DBMS as your target.

... and consider that the column names that you see when you open the
table in Access might not be the _real_ names of the columns! Show at
the "design" view of the table to find out what the real column names
are.... this cost me some hours and right now I like Access a litte more
less (awesome rhyme...)

cu!
Martin

Reply to this Message

David Rabinowitz - 30 May 2004 09:04 GMT

You can use mdbtools (http://mdbtools.sourceforge.net/) to convert it so
other format

David

> Hi,
> is there any way to get the data of a 'Microsoft-Access-Database' with Java
> under Linux?I have got only the .mbd file and no Windows...
>
> greez fabian

Reply to this Message

Davis - 31 May 2004 17:10 GMT

> You can use mdbtools (http://mdbtools.sourceforge.net/) to convert it so
> other format
[quoted text clipped - 6 lines]
> >
> > greez fabian

David - have you actually used mdbtools? The project on SourceForge
seems pretty dead but I have been thinking of reviving it and porting
to Java. That would make it not TOO difficult to get a JDBC driver
going for Access files which would be a cool Open Source project.

Reply to this Message

calvinrsmith - 17 Jun 2004 23:53 GMT

mdbtools is now ported to java. there is a module in the cvs for it

> > You can use mdbtools (http://mdbtools.sourceforge.net/) to convert
> it so
[quoted text clipped - 7 lines]
> to Java. That would make it not TOO difficult to get a JDBC driver
> going for Access files which would be a cool Open Source project. *

--
calvinrsmith
------------------------------------------------------------------------

Reply to this Message

'Microsoft Access Database' with Java.

Free Magazines