Good question, Ed. I’m copying this to the list. An expanded version should be included in the DHIS2 documentation:
There are several options for GUI clients to manage H2 databases. H2 itself comes with a nice web interface which is quite capable. Otherwise, it is supposed to support the Postgresql ODBC driver http://www.theserverside.com/news/thread.tss?thread_id=46456. This should allow the use of MS Access as front end, which I tried to do something with that some time back, but ran into some problems (cannot recall exactly).
An alternative is to use the JDBC driver and connect to one of several clients. Two that we have used are NetBeans or OpenOffice (similar to Access):
http://www.oooforum.org/forum/viewtopic.phtml?t=97522
Knut
···
On Wed, Mar 24, 2010 at 1:02 PM, Robinson, Ed ERobinson@futuresgroup.com wrote:
Thanks a lot for your input Knut. Do you recommend any third party gui to work with H2 databases?