News for hackers. Stuff that matters.
Re:Microsoft Access: The Database Software That Won't Die by tracker1 on Wednesday October 30, 2019 @04:46PM (#21402488)
I think that Open/Libre-Office have options for this. You can also use Access as a front end for another db (odbc) backend pretty easily.

I'd probably do a web app myself, but that's just me. I know a lot of people that cut their programming teeth on Access apps, including distributed ones.

Re:Microsoft Access: The Database Software That Won't Die by tabtab on Wednesday October 30, 2019 @04:55PM (#21402595)
OO/LO "Base" is a pile crap in my opinion.

People often develop smallish CRUD apps in MS-Access in two weeks or less. It's up and going without fuss and muss and without fiddling with servers, containers, DBA's, etc.

You have to admire its nimbleness.

Yes, the database "crashes" fairly often, but it's easy to make frequent round-robin-style file-based backups using Windows Scheduler and DOS scripts.

Most databases cannot be properly backed up with file-based techniques because of syncing of internal pointers. But MS-Access's separate "lock-file" based technique somehow facilitates file-based backups.

Such MS-Access apps are far from perfect, but if you factor in everything, they seem to be a net benefit.

I'd probably do a web app myself

If follow-on maintainers don't know the web framework used, it can be hard to maintain. Web apps are rarely nimble to do without an involved framework on which the developer is familiar with. MS-Access avoids that problem with ubiquity and a light drag-and-drop learning curve. (It did get harder to learn when they went from coordinate-based to an HTML-esque flow engine around 2006.)

Let's face it, desktop GUI IDE's are usually much easier to learn than web stuff. You don't have to deal with the web's lack of state, and CSS/DOM/JS headaches/bugs/inconsistencies.

Re:Microsoft Access: The Database Software That Won't Die by zokier on Wednesday October 30, 2019 @05:13PM (#21402805)
Whats wrong with Base? I haven't used it so I don't have any preconceptions about it.
Re:Microsoft Access: The Database Software That Won't Die by tabtab on Wednesday October 30, 2019 @05:34PM (#21403021)
Re: Whats wrong with Base?

When I first learned MS-Access, I barely had to read the manual. I could discover most functionality by clicking around. With Base, I had to constantly dig in the manual and still couldn't get it to do many ordinary CRUD idioms.

Re:Microsoft Access: The Database Software That Won't Die by blihp on Thursday October 31, 2019 @01:58AM (#21406095)
It's a clunky front-end with a fragile back-end. While it superficially resembles Access if you squint your eyes, it can't provide more than a small fraction of its utility currently. Too many missing/broken bits.

I spent a couple decades as a power user of the MS Office suite and find that I can generally make Calc do what I need as a spreadsheet and even Writer as a word processor. However, pretty much every time I've tried to develop a solution in Base it turns into a fight and I end up throwing up my hands and going with a different database solution. Calc doesn't even work all that well with it... and it's one of the few applications that works with it at all.

Re:Microsoft Access: The Database Software That Won't Die by fencepost on Wednesday October 30, 2019 @05:53PM (#21403230)
I'd probably do a web app myself

Running on? Wait, you mean I have to get IT to set up a server for me? Who's responsible for maintaining that? Backups? They're going to do that for something used by only 10 people that saves us maybe 20-30 hours a week? How much are they going to charge my department for this?

Re:Microsoft Access: The Database Software That Won't Die by alexis_fr on Wednesday October 30, 2019 @07:26PM (#21404128)
A company like Atlassian famously often had their first install at customers performed by employees on a rogue box under-the-table. Seems like it’s how one introduced software in the 2000s.

I wonder whether today’s equivalent could be made on Raspberry Pi. It requires a few tricks, but there is so much demand from managers who could afford paying 50€ out of pocket.

Of course, having a rogue box plugged to the internal network with a Wifi and Bluetooth chip on board is not IT-approved. Can it be bypassed?

Re:Microsoft Access: The Database Software That Won't Die by zokier on Wednesday October 30, 2019 @05:11PM (#21402785)
LibreOffice has Base which can use either embedded database system or talk to proper RDBMS like postgresql. KDE has Kexi which afaik is pretty similar. I have no experience with either, nor have I ever heard anyone to use them.
Re:Microsoft Access: The Database Software That Won't Die by alkonaut on Wednesday October 30, 2019 @05:05PM (#21402719)
Yeah it doesn’t feel like something more than an access clone. I’d like something that is as easy as access but can also be migrated to a modern web+db app with ease. Even if it requires some minimal coding ability it would be cool to be able to make an Elm crud app deployable as a container, starting from an access-like set of tables and forms.