I'm just tossing out some ideas.
Do you have access to an ODBC driver for Jet 4.0 in Linux?
You'd be able to then use whatever standard data access tools
are provided by gcc or g++, right?
Alternately, if you can load or link ActiveX DLLs in Linux, then
you could access the data in the MDB file using the ADO object
library (which is freely available through Microsoft's MDAC 2.8
download).
As far as I know, the actual file format for the Access MDB is
proprietary, so I don't know how you'd get at the data outside
of ODBC or ADO. If anyone has found a way to hack it, though,
it'd be someone in the Linux community.
dubing@gmail.com wrote:[color=blue]
> Hello,
>
> Here is what we need to do. On a Linux Apache server, we need to
> write PHP or Perl scripts to pull the data directly from the Access
> database and display extracted data on the web. Anybody have done that
> and would like to share how?
>
> I've looked dbmtools. But it seems to be a command line based tool.
> Also it's good for transferring data from Access to other databases,
> like mysql, db2, etc. I've also tested Easysoft ODBC-ODBC Bridge. It
> works for Access. But it's not open source. FreeTDS/unixodbc is open
> source but FreeTDS is for MS SQL server and Sybase.
>
> Thanks in advance for any ideas.
>
> Bing
>[/color]
