A few newbie questions
Hi. I have an Office 365 subscription. I have played around with Access for years, but am now pretty much fed up with Microsoft's failure to fix bugs and its reliance on VBA, a dinosaur of a programming language.
I have a few database needs that I don't think Access can handle or, if it can, I don't want to
have to do it in VBA. I am looking for something more modern, like Python.
A few of them involve allowing multiple other users to access the database. These would mostly be front-end forms that the user could fill in and get some answers. Some of them could be simultaneous.
One is a bit more involved. I have collected about 1,000 vinyl record albums (LPs) from various neighbors who no longer want them (donors). I have about 25 other neighbors who do want them (takers). I have the LPs in an Access database with as much information as I could find (title, date, artists, tracks, etc.).
My plan was to give each taker a password that they could use to access the database. When they do, they will see the album data like a spreadsheet in read-only mode, which they can sort and search. They would also see one read-write column that belongs only to them and which they can use to indicate which LPs they want.
When all of the takers have finished making their selections, I would write some code to do the allocation using an algorithm that I am working on to resolve ties as fairly as possible.
The information that I am getting is that Access really cannot handle this task. So my question is, can MySQL? If so, which version do I need?
If MySQL is not the best tool for this project, can someone recommend one that is?
I appreciate any help.