Business: Windows Access DB ----> Linux OSS DB
I'm looking around for options to replace a completely windows run business which relies on ms access to keep track of customers, equipment, sales, etc.
I am aware of mysql and postgre, but I am curious what else exists out there.
The end-goal would be a completely linux environment, a database system that would allow pretty much the same functionality of ms access (ie: customizable forms, reports, etc). It doesn't have to be point-and-click like access, but that would be a bonus. I'm trying to get away from the extreme cost involved (Office Pro ~ $400 ea, plus windows ~ $120 ea) - at that cost to upgrade/replace all 10 antiquated client machines I'm looking at over $5000 and that doesn't include ANY hardware.
I am also aware of Open Office and that database system. But I am leaning toward mysql.
What options are available to create a front end for a mysql database?
What have any of you used and why do you like/dislike it.
BTW: we have a bunch of slow learners at work.