I am developing a new application using MySQL instead of MS SQL Server 2000, I have just shelled out for the Microolap Delphi SQL DIrect Access Components, having successfully converted an existing SQL Server database to MySQL.
HOWEVER, I have tried using MyCC, MySQL Explorer, and PremiumSoft MySQL Studio to add a new field to a simple table, and I keep getting an error message like [localhost] ERROR 7: Error on rename of '.\rocktest\companies.MYI' to '.\rocktest\#sql2-94c-21.MYI' (Errcode: 13) If I save to a new table it works, but of course the data is not copied. I am running Windows XP Professional, MySQL 4.0.1-alpha-nt. Anyone know what's wrong? What do other people use to edit table structures (and don't say SQL queries because that's not a productive option when compared to MS Access linked to SQL Server. Regards Jeff Dyer Logic Software Design www.logicsoftware.co.uk --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php