Slashdot Mirror

Kexi reads Microsoft Access databases.

See more at http://www.kexi-project.org/wiki/wikiview/index.ph p?MDBDriver

OpenOffice.org Base reads Access too:
http://dba.openoffice.org/ (MDB tools for Linux)

Oh, and so does Knoda::
http://www.knoda.org/

I'm sure that there are more apps that can read Access files. I think the Access functionality is done by mdbtools.

I've also used MS Access 2000 on Wine, and it worked quite well. I have to disagree with you about emulation: If you want to run GNU/Linux, and need one or few Win32 applications running on it, why not run them on Wine?

So not a big issue IMHO :)

Eleknader

Try Knoda for managing your database and some RAD tools like Eclipse or KDevelop.

Another pair which might work very well at a reasonable price are KDE Studio Gold and Data Architect from theKompany

YMMV - I've had no experience with any of these programs. I develop with dia, vim, and a command-line SQL client.

And don't forget knoda

I think Knoda sounds like an exact match. Feature list:

* define and delete databases;
* create, alter and delete tables and indices;
* add, change and delete data in tables;
* define, execute and store sql queries;
* define, execute and store queries with a "query by example" GUI;
* import and export CSV data;
* define and use forms;
* define and print reports; and
* write your own extensions using the integrated Python interpreter as scripting language

This is the Open Source equivalent of MS Access and Filemaker, except that it can use any database backend (native MySQL, PostgreSQL and SQLite support, plus ODBC). The report and form designers are full WYSIWYG GUIs, like the commercial counterparts.

Possible disadvantage? It requires KDE3, so it does require quite some extra bagage you don't normally find on a Mac OS X system, but it *should* work.

For a good bit more work, but less money and the karma boost of avoiding proprietary (and somewhat buggy) Access, it looks like OpenOffice has rudimentary support for databases. Take a look at the UnixODBC project, specifically this PDF, which seems to do a decent job of explaining the steps involved. Note that I've never tried this, but it certainly looks workable. As a bonus, you should be able to use any database with an ODBC component.

Of course, you could always go with dBase (who bought some of the rights from Borland), who have a web enabled dBase version. It'll need to be hosted on a Windows machine, it looks like though.

You may also want to take a look here which lists Windows and *nix xBase compatible programs. xBase was (is?) a standard that dBase, Clipper, FoxPro and others adhered to. Perhaps you'll find something there. Also, there was a dBase for UNIX at one point...I don't think it's still for sale, but you may be able to turn up a copy on eBay or something.

One last suggestion would be KNoda which is a KDE frontend that allows for queries, forms, and table design. It looks a bit like Access, though, once again I haven't tried it.

That should start you on your research...good luck.

I'm not aware of anything like it, but Knoda is a MySQL front-end, that looks like it is slowly adding forms and reports. They also posted an update yesterday to support PostgreSQL.