Linux/Java - Connection to MS Access database

[mr_welby]

Hi,

On my Linux machine, I need to connect to a MS Access database. I noticed that OpenOffice 2 is able to connect to it by using the Database wizard.

- How the connection is done?
- Which driver is used to connect to it?
- Is there a way to run the wizard in background?
- Where can I find the part of code which is used to connect to a MS Access Db?

Kind regards,

Welby

[DrewJensen]

The Linux distributions have for the most part dropped MS Access as a supported connection type. The feature was relying on MDBTools and this was seen as not stable enough for production use.

Some have tried using ODBC under linux with the same driver to connect but it appears they are having very little luck - I beleive that bottom line is that if you really want to use Base with MS Access you need to be on Windows.

If all you want to do is migrate the data to a Base file, then you can export the data from MS Access into csv files and import it under Linux.

[mr_welby]

Thanks for you reply.

It seems that the migration is inevitable.

I will export the data from MS Access into csv files and import it under Linux.

Thanks,

Welby