Recommend a database

[drummondjacob]

I am building an intranet (to be hosted on a Windows XP Professional running IIS 5.1) that includes messaging capabilities and need an appropriate database format:

I cannot use MS Access as it has a 2Gb file size limit and a 255 <I>character</I> limit on the text fields.

The only downside of MySQL is that I cannot find a free or cheap GUI for creating and editing tables. (Any recommendations for GUIs welcome.)

I would us Lotus Approach but each database can only contain a single table which means multiple databases and therefore more organisation, ODBC sources and DSNs to set up.

I cannot use MS SQL as I am not running Windows Server 2000/2003 or NT.

Please can somebody recommend a database system/format/server with a relatively good GUI.

P.S. I do apologise for the lack of clarity and knowledge in this post.

[Chroder]

What about MySQL Administrator (http://www.mysql.com/products/administrator/) (Download (http://dev.mysql.com/downloads/administrator/1.0.html)) and MySQL Query Browser (http://www.mysql.com/products/query-browser/) (Download (http://dev.mysql.com/downloads/query-browser/1.1.html))? You should look into phpMyAdmin (http://www.phpmyadmin.net/home_page/) (the most popular MySQL administration tool) if you're deciding to install PHP as well.