Knoda Meets MS Access

Knoda is a database frontend for KDE. Besides tables and queries, Knoda lets you create forms and reports, scriptable via Python. With its latest release, Knoda has introduced a driver for MS Access databases (mdb files). Knoda is the first KDE-based database frontend to be able to read MS Access databases natively and is getting closer to its goal to be a full replacement for MS Access.

The mdb driver is based on mdbtools. Another driver has also been added to support read-write access to Dbase (.dbf) files which is based on Xbase.

Also introduced with this version of Knoda is the possibility to import and export to and from different database servers.

Drivers for MySQL, PostgreSQL, SQLite and
ODBC are also available.

Dot Categories: 

Comments

by Matt (not verified)

Very helpful features!
This will help me to move some legacy databases from MS Access to Linux.
Thanks!

by Ziggy (not verified)

Does this compile on Freebsd yet?

by AlecN (not verified)

On FreeBSD:
cd /usr/ports/databases/knoda; make install
Don't forget to upgrade your ports tree to the most current version

by ac (not verified)

Ever heard of FreeBSD ports? And if you're going to go all BSD on us, maybe you can learn how to fix source compilation errors while you're at it?

by Ziggy (not verified)

The last 2 versions i tried out of ports failed misreably. Thus why i asked my question.

As far as fixing it myself, i have a day job.. no time for that.

by KDE User (not verified)

Does this app have the same goals as Kexi?

Which is more complete?

by Lee (not verified)

I'm not sure if it has the same high goals as Kexi, but it certainly works more easily and reliably, from what I've seen so far of both.

Give it a try. Knoda is a deceptively powerful little thing, which gets much less press than it deserves :)

by Jaros³aw Stanie... (not verified)

No offence, but commit dates for working features compared:

---Kexi: (cvs log from kdenonbeta/keximdb/)
date: 2005/03/06 18:02:24; author: martin; state: Exp; lines: +0 -0
This is keximdb, the MDB file migration driver for Kexi.

MDB files are the native database format of MS Access (and
also some other MS applications). This driver can be used
by Kexi's migration framework to convert simple Access
databases in to native Kexi databases.

Use the keximigratetest program, or use 'Import' - which is
under Kexi's file menu if you follow the instructions at
http://www.kexi-project.org/wiki/wikiview/index.php?AdvancedBuildNotes
- to test.
[...]------------------

(subsequent commits also mentioned in KDE CVS Digest, http://cvs-digest.org/index.php?newissue=mar182005)

---Knoda: (cvs log from cvs.sourceforge.net:/cvsroot/hk-classes/)
date: 2005/03/27 16:33:44; author: knorr; state: Exp;
driver for .mdb files (MS Access) added
-------------------

And BTW, we're importing data and then -opening, not 'opening native' MDB files. Let's avoid vapourware-like statements. :)

by Pat (not verified)

"This driver can be used
by Kexi's migration framework to convert simple Access
databases in to native Kexi databases"

Does this mean that complexe Access databases can't be converted? I wonder how advanced are those mdbtools.

by Iuri Fiedoruk (not verified)

The main problem I have with it (using 0.7 on Suse 9.2) is that the interface is very confusing.

Kexi looks fine, but it's hard to find without koffice package, and when I tryied to compile it agains my KDE 3.4, it just didn't worked.

by Jaros³aw Stanie... (not verified)

1. For users convenience there are also separate releases outside KOffice, with packages following these quidelines:

http://www.kexi-project.org/wiki/wikiview/index.php?HintsForMakingKexiPa...

2. E.g. Debian, thanks to great cooperation, is well supported for 10 architectures: http://packages.debian.org/unstable/kde/kexi

Regards

by Pat (not verified)

why is kexi still labelled 0.1beta? it looks really fullfeatured and last time i checked it was pretty stable.

by Jaros³aw Stanie... (not verified)

psst, the jump is planned in a few days or so...

by Pat (not verified)

cool :) thanx for the great work, I've tried kexi when it was first posted on the dot before the big framework rewrite and I also tried it last year. I think i'll give a try this time again. I hope Qt4 will make your port to windows easier too.

by Iuri Fiedoruk (not verified)

Yes, I knew there was a separated release, the one that I compiled and didn't worked was this one.
To avoit talking nonsense I'vbe even tryied to compile from CVS, much better, but still can't open a mysql database, and postgres support dosen't compile, even that I have the devel package.
But working with a file database seems ok and works.

by None (not verified)

It has been over a year since last I looked at what was happening on the Linux Desktop database front. I had foolishly though that nothing had changed and that the best I could hope for was one of the GUI frontends to MySQL. Now I see this!

WOW! There are now three desktop database applications, Kexi, Knoda and Open Office Base and the K programs can read MS Access files. FANTASTIC!

by Morty (not verified)

You didn't look very hard a year ago then, or else you should have found Rekall. It has been around since the KDE/Qt2 days. It has seen production use for several years, and it is available as GPL.

by Tobias Koenig (not verified)

It wasn't available under GPL one year ago...

by Morty (not verified)

It was, Rekall has been GPL since 17 november 2003. http://dot.kde.org/1069090495/

by None (not verified)

Rekall is nice but, to my knowledge, it is not able to read MS Access files. Did I miss something?

by Terrell Prude', Jr. (not verified)

I think that this app's existence is great. I don't use MS Access myself, but given the desktop popularity of Microsoft Access thanks to its bundling with MS Office Professional, I think it's a terrific thing for more than one client to be able to open Access databases, particularly one that's Free Software.

Kudos to you, and may your application, and any other application that does something similar, be a great success! You already are a success at this point anyway for creating Knoda, as is anyone else who has done similar work.

Thank you, and well done.

--TP

by Ferdaus Al Amin (not verified)

Itś just favulous to know that several databse appś are now there to read MS Access