Re: MS Access

On 8/13/24 5:46 PM, Lawrence D'Oliveiro wrote:

On Tue, 13 Aug 2024 01:31:15 -0400, 186282@ud0s4.net wrote:
 

On 8/12/24 4:41 AM, Lawrence D'Oliveiro wrote:
>

Naturally, LibreOffice Base supports all that as well.

>
Well, never say "naturally" - what's in v9.10 might not be in v9.11

 I know regressions happen a lot with proprietary software: “let’s save
that feature for the Pro version”. Less common in Open Source, though:
stuff only gets removed when nobody cares about it.
 

LibreOffice allows for more modern scripting languages, like Python.

>
ANYway ... the most common subthread here is whether Access is still
worth it.

 Given that LibreOffice does it all, and is available for less cost and
with fewer restrictions, the answer has to be no

   I'll have to get further into it ... but meanwhile
   I will not just assume "LibreOffice Does It All".
   They DO try - cudo's to them ... but it's still a
   constantly evolving situation. M$ keeps changing
   things - mostly to throw off competitors rather
   than for basic function IMHO.
   Meanwhile, I'll still say Access was one of the
   enlightened products of M$ ... "good enough",
   and cheap enough, for a LOT of uses.
   As I said elsewhere, I've writ a few full Access
   apps - one for commercial sale - in the past.
   I found it, plus VBA, more than adequate for any
   common purpose.
   TODAY, DBs tend to be much LARGER - full of embedded
   pix/video/GIS - so Access limits may NOT suffice depending.
   There ARE tricks to handle Big Data, but you kinda have
   to design properly from start.
   But, again depending, Access MAY be completely adequate
   and 'standard'/'established'. M$ HAS done SOME good
   over the years ... alas eclipsed by all the BAD ....
   Modern SQL flat-file DBs ... DON'T like them much.
   Gimme something more like PICK ... multi-value
   and WYSIWYG form design. OpenInsight is a fair
   reference ... Advanced Revelation before that.
   This is MY "ideal", my "how it should be".