List:General Discussion« Previous MessageNext Message »
From:Gerald Clark Date:July 26 2002 1:57pm
Subject:Re: Error updating table structure.
View as plain text  
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 <mysql-thread115627@stripped>
>To unsubscribe, e-mail
> <mysql-unsubscribe-gerald_clark=suppliersystems.com@stripped>
>Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
>


Thread
Error updating table structure.Jeff Dyer26 Jul
  • Re: Error updating table structure.Gerald Clark26 Jul