APR
27
2005

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.

Comments

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


By matt at Wed, 2005/04/27 - 5:00am

Does this compile on Freebsd yet?


By Ziggy at Wed, 2005/04/27 - 5:00am

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


By AlecN at Wed, 2005/04/27 - 5:00am

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 ac at Thu, 2005/04/28 - 5:00am

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 Ziggy at Fri, 2005/04/29 - 5:00am

Does this app have the same goals as Kexi?

Which is more complete?


By KDE User at Wed, 2005/04/27 - 5:00am

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 Lee at Thu, 2005/04/28 - 5:00am

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 Jaros³aw Stanie... at Wed, 2005/04/27 - 5:00am

"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 Pat at Thu, 2005/04/28 - 5:00am

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 Iuri Fiedoruk at Wed, 2005/04/27 - 5:00am

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 Jaros³aw Stanie... at Wed, 2005/04/27 - 5:00am

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


By Pat at Wed, 2005/04/27 - 5:00am

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


By Jaros³aw Stanie... at Wed, 2005/04/27 - 5:00am

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 Pat at Wed, 2005/04/27 - 5:00am

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 Iuri Fiedoruk at Thu, 2005/04/28 - 5:00am

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 None at Thu, 2005/04/28 - 5:00am

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 Morty at Thu, 2005/04/28 - 5:00am

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


By Tobias Koenig at Thu, 2005/04/28 - 5:00am

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


By Morty at Thu, 2005/04/28 - 5:00am

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


By None at Fri, 2005/04/29 - 5:00am

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 Terrell Prude', Jr. at Wed, 2005/05/04 - 5:00am

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


By Ferdaus Al Amin at Sat, 2005/05/07 - 5:00am