[ale] Linux Frontend to MS Access

[Jim Sculley]

Brian Pitts wrote:
> Warren Myers wrote:
>> Anything that supports ODBC should be able to work
>
> The problem with this as I understand it (and I'm not certain I 
> understand it very well, that's why I'm asking here) is that there is 
> no Linux ODBC driver for Microsoft Access (ie Jet) that has write 
> support. MDB Tools [1] has an ODBC driver for Jet, but according to 
> their website write support isn't implemented yet. Judging from their 
> mailing list, MDB Tools development has stopped. Unixodbc's website 
> lists the commercial ODBC-ODBC Bridge from Easysoft [3], "a 
> client/server product that allows an ODBC application to access an 
> ODBC driver on a remote machine", as the only option.
>
> > depending on what
> > he needs, you can do it with PHP.
>
> Writing a web application that runs on Windows and thus can use 
> Microsoft's DAO or ODBC drivers sounds like a possibility. The other 
> possibility is to migrate the data to another database that both MS 
> Access and a Linux database program can read and write to, such as 
> MySQL. [4]

Or, a Java application acting as a server on the Windows machine 
connecting via the JDBC-ODBC bridge.  Client on the Linux machine 
talking to the server via RMI or some other means.

Jim S.