dstiles - 10:38 pm on Mar 16, 2010 (gmt 0)

A note on my earlier posting mentioning Access databases. Just found Gnome MDB File Viewer gmdb2 - "view and export data and schema for Access versions 97/2000/XP/2003". I must have installed it when I was looking into transferring an MDB to Open Office and then forgotten it.

In theory it allows you to view and export MDB files. It offers several Schema export formats (I tried MySQL) but not OO. It includes a SQL query window plus forms, reports, macros etc. Would probably work up to a point but I don't think I ever got too close to it due to lack of time. Schema export allows you to include Relationships and Drops; no idea how the former is implemented.

I think this would be useful if I needed to transfer MDB to MySQL for use on a web site where relationships were controlled via code on the site.