MySQL Forums
Forum List  »  Newbie

A few newbie questions
Posted by: Jennifer Murphy
Date: July 31, 2024 05:14PM

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.

Options: ReplyQuote


Subject
Written By
Posted
A few newbie questions
July 31, 2024 05:14PM
August 01, 2024 09:26AM
September 25, 2024 09:40AM
August 02, 2024 01:52AM
September 11, 2024 11:12AM
September 25, 2024 09:42AM
August 02, 2024 04:40AM
September 25, 2024 09:43AM
September 25, 2024 09:46AM


Sorry, only registered users may post in this forum.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.