up vote 1 down vote favorite
share [g+] share [fb]

Are there any good tools out there (don't have to be be free) that provide functionality analogous to MS Access but for non-MS databases like MySQL? I'm looking for more than just a query builder like MySQL Workbench. But something that allows power users to build read/write forms to modify database contents, and then non-power users to use those forms.

Of course there are a zillion web development solutions to this problem. What I'm looking for is something that allows somebody who's technical but not really a developer to easily create forms that allow others to modify a database.

Ideally the system would work on either windows or mac. But if there's something great that's only available on one, we could deal with that.

link|improve this question
75% accept rate
What OS do the forms need to run under? What environment will you be making it under? – Luke Aug 9 '11 at 20:10
Good question. Clarified. – Leopd Aug 9 '11 at 20:21
2  
@Leopd - Are you aware you can hook Access up as a front-end to a back-end MySQL server via ODBC? – techie007 Aug 9 '11 at 20:31
For both Windows and Mac, I would suggest FileMaker, except it's not MySQL – Luke Aug 9 '11 at 20:38
I might also add, you can use MSSQL DBs generated by access as a backend for Django. If you're crazy, just like me. – Doc Aug 9 '11 at 22:06
feedback

2 Answers

up vote 1 down vote accepted

Maybe Libre Office's "Base" would work for you? I've never tried it myself.

"there are a zillion web development solutions to this problem" -- like Django? Sort of applies.. I love Django, but I think you're looking for something created through a GUI.

link|improve this answer
feedback
up vote 1 down vote

Absent the Mac requirement (unless you're using Parallels) I would suggest that your best bet is Access. It has no trouble working with MySQL data.

Your question strikes me as quite odd because of that. The only part of Access that is limited to MS SQL data is ADP, but that's deprecated even for SQL Server these days in favor of MDB/ACCDB with ODBC linked tables. In that regard, MySQL is completely equivalent to SQL Server in terms of what's supported.

link|improve this answer
feedback

Your Answer

 
or
required, but never shown
discard

Not the answer you're looking for? Browse other questions tagged or ask your own question.