I would like to move to a better backend and front end. Local first would be good over a database server. I've been looking at flutter and sqlite but I've little experience here and am unsure about a multi user context.

Access whilst old is a good technology when used correctly within its capabilities.