If you are going to use access as the development tool and it's always going to be a small number of users and a small amount of data and it's not that critical, then OK access is a choice. A bad one, but possibly a practical one.

If you are using access to be mobile, ie carrying the mdb about locally and then resynching with a main database, or passing it between users without a constant connection, then mobile is now a much better choice.

If you are using it because it's called a database and you got it free with office, then you are doing yourself no favours at all.

As an investigation tool for power users, preferably off a copy of the live data, it still has some attractions, to write professional systems with, total non starter.

The real nightmare is when your requirements outgrow a desktop database, porting it over to a more full featured one, you either end up with a really crappy solution, or you have to rewrite from the ground up.

There are other free DBMS's that don't come from MS of course.
So it's not one or the other.