Re: 'Microsoft Access Database' with Java.

From: Martin Schmid (martins_at_florian-mueller.de)
Date: 06/01/04 

Date: Tue, 01 Jun 2004 12:00:08 GMT

Luke Webber wrote:

> "Chris Smith" <cdsmith@twu.net> wrote
>
>>Fabian Rossbacher wrote:
>>
>>>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.
>

... 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

Relevant Pages

  • Re: Microsoft Access Database with Java.
    ... > Fabian Rossbacher wrote: ... If you want to use a database, you'll need DBMS ... > functionality of Microsoft Access in a JDBC driver any time soon. ...
    (comp.lang.java.databases)
  • Re: Is there any way to connect database without JDBC?
    ... and some application has conflict with JDBC. ... control on the application, but we still need to connect to database. ... Which DBMS you need to support? ...
    (comp.lang.java.programmer)
  • Re: Microsoft Access Database with Java.
    ... No, JDBC isn't magic. ... If you want to use a database, you'll need DBMS ... No one is likely to rewrite all of the core ...
    (comp.lang.java.databases)
  • Re: Mixing P/R philosophy with OO (within J2EE).
    ... I have observed the work of literally hundreds of Java developers. ... Treating a database like a mere "persistence storage mechanisms" is on ... JDBC - Never before in history were so many database API's ... Topmind, if you're reading this, isn't this a good example of OOP? ...
    (comp.object)
  • Re: What does everyone else do for graphically displaying data?
    ... JDBC API reference cover to cover a couple of times, ... you bind a data grid to a database table so that when you edit the ... put all JDBC code in the Model classes. ... Use something like Hibernate. ...
    (comp.lang.java.databases)