Slashdot Mirror

← Back to Stories (view on slashdot.org)

KDE Knoda Meets MS-Access in New Release

Posted by timothy on from the chipping-away dept.

An anonymous reader writes "Horst Knorr released a new test version of Knoda. With this release Knoda is the first KDE database frontend reading MS Access databases natively and is getting closer to its goal to be a full replacement for MS Access. Knoda is a database-frontend for KDE. Besides tables and queries Knoda comprises forms and reports, which are scriptable via Python."

5 of 57 comments (clear)

  1. good for small businesses by sfcat · · Score: 4, Interesting

    MSaccess is used to run alot of small businesses (who think that Access is somehow better than Excel). It would be nice to see if Knoda would also support more db like functionality (like transactions maybe) with autocommit turned on so that it seemed to work like access. Also, if you could make this have some transparent SQL layer so it could be a front-end to real databases (mySQL, etc.). But another barrier for some to migrate has been overcome. Good work.

    --
    "Those that start by burning books, will end by burning men."
    1. Re:good for small businesses by cyranoVR · · Score: 4, Interesting
      Good luck doing an update query in Excel...

      ...or constraining user input in Excel

      ...or quickly/easily finding duplicate entries (and I ain't just talkin' about the "Find Duplicates Wizard" as convenient as that is...)

      ...or quickly sorting a list in Excel without screwing the whole thing up (remember to select every column!)

      ...or having more than one person at a time edit an Excel spreadsheet (especially when "the meeting's in 20 minutes!!!")

      ...or having users that use cell colors and font formats to organize their Excel data (ummm...how do you sort blue, orange and yellow?)

      ...or (my personal favorite) getting those &$%@ing page breaks set exactly how you want them.

      When I am Supreme Chancellor, Excel will only be used for financial analysis. Those who mis-use it as a "database" will be whipped in the public square. No, I'm not bitter :\

  2. Re:Access is evil by iendedi · · Score: 3, Interesting

    Hopefully, the intent is to migrate Access installed base off of access and into the sane world.

    --

    It is your personal duty to fight for what is right on a daily basis. Ignoring injustice is identical to approving
  3. Access is great for data conversion by FriedTurkey · · Score: 3, Interesting

    MS Access isn't total crap. It is great for data conversion. It's a lot easier to fix a bunch of spreadsheets in Access and move it to a real database like Oracle or DB2. Moving between database types through ODBC is easy and you can clean out rows with a touch of the delete key. There are expensive tools that do the job but why get them when Access does it. Nothing is more painful than dumping to text files and using a tool like Oracle SQL*Loader.

    Having said all that I would never use MS Access for a real application. :-)

  4. Rekall is not bad by auferstehung · · Score: 4, Interesting

    Rekall is not a bad database frontend with Access like style, but that can be used with a range of database backends (mysql, postgresql, etc). Like other Kompany products its is even dual licensed under the GPL. See RekallRevealed.Org

    --
    Logic is not Divine.