mysql doesn't own the table or database. Jeff Dyer wrote:
>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 > > --------------------------------------------------------------------- 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