> > mySQL, hands down. With the right GUI front end you also have an easy > and very powerful environment to work in. The free/donationware > mySQLFront (http://www.mysqlfront.de) is my favorite. >
Thanks for the tip-- this is definitely the best Windoze MySQL front-end I've used. I've been using MyCC for close to a year, and its super quirky. I've been using it with in combination with phpMyAdmin to get past its shortcomings. I just used the "Export Tables" tool in MySQL-Front to move data from one database to another, and it worked flawlessly. If you didn't know it already, phpMyAdmin is an awesome web-based front-end for MySQL. I love the command line, but its just not a sufficient tool for managing a database. (I use MySQL on Linux and FreeBSD) As far as MySQL vs. Access, it will certainly take more time to configure and learn MySQL, but you'll be glad you did in the long run. Downloading the above GUI will make it very simple to work with once you get it setup. IMHO, if you need a book, the best MySQL book is MySQL by Paul DuBois. Personally, I think anyone having problems with Access that can't afford MS SQL Server should really consider moving to MySQL. - Brandon -------------------------------------- http://spooled.net http://booms.net FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
