Hats off to you, and thanks very much for the response ... I agree with your "it isn't difficult" remark, and to be completely blunt, it is so 'not difficult' that I was sorta fishing for leads on stuff that is already done. This is a low-priority project that I am not getting paid for ... and this kind of work was old-hat for me over ten years ago ... so perhaps you can understand the question is less 'proof of concept' and more 'anybody got some spare code'.

As far as the "MSFT Access hell" all I can say is "I feel your pain (been there done that)" In fact, memories of this past anguish is partially what prompted my question.

It seems as though there is an "unmet market niche" out there ... small(ish) desktop database with the elegance and power that only a perlmonk could love, but with the pointy-clicky approachability that is the strong-suit of the (otherwise inelegant) MSFT Access category (which is what basic users need). Perhaps those two realms are just too distant, like finding someone who is fluent in both English and Mandarin Chinese?

So for now, it looks like a coin-toss between MySQL-Perl-Tk and (hold my nose) MSFT Access or Spreadsheet. Not to bash MSFT but their scripting and performance leaves a *lot* to be desired.

BTW I am suprised no one mentioned Open Office ... I'm still wondering if there's *anything* else out there

In reply to Re^2: slightly OT "Desktop Database" options by dimar
in thread (OT) "Desktop Database" options by dimar

Title:
Use:  <p> text here (a paragraph) </p>
and:  <code> code here </code>
to format your post, it's "PerlMonks-approved HTML":


  • Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!
  • Titles consisting of a single word are discouraged, and in most cases are disallowed outright.
  • Read Where should I post X? if you're not absolutely sure you're posting in the right place.
  • Please read these before you post! —
  • Posts may use any of the Perl Monks Approved HTML tags:
    a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, details, div, dl, dt, em, font, h1, h2, h3, h4, h5, h6, hr, i, ins, li, ol, p, pre, readmore, small, span, spoiler, strike, strong, sub, summary, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr
  • You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)
            For:     Use:
    & &amp;
    < &lt;
    > &gt;
    [ &#91;
    ] &#93;
  • Link using PerlMonks shortcuts! What shortcuts can I use for linking?
  • See Writeup Formatting Tips and other pages linked from there for more info.