Re: Gets a bad rap
Access predates all this modern open source stuff like MySQL, MariaDB etc. You were *supposed* to use Access, and in the absence of anything else, it's what you did.
When Access was all the rage (late 90s) there were no real viable alternatives. You had this database app (lication - we didn't call them apps) bundled with your word processor and spreadsheet - why wouldn't you? These were the days when you sent half the office off to a local hotel for the day (lunch provided!) for a beginners training session with each of the Office programmes and they came back empowered, enthusiastic and ready to wreak well-intentioned carnage with Excel and its big brother.
And, tbf, as others have previously stated, it was fine, at least until it wasn't. As a quick prototyper or a system for a small workgroup, it could cope. It's when it grew, and grew and grew that you had problems. For a while, you could get by by separating the data from the front end (call in a proper developer on a day rate!) but ultimately record locking and file security were waiting to bite you, maybe not today, maybe not tomorrow, but some day.
I switched my lovingly created classic ASP-based intranet app from Access to MySQL in a weekend as I recall. As soon as there was a viable alternative, I fled to a "proper" database. But in the 90s? Access was king.