List:General Discussion« Previous MessageNext Message »
From:Jeffrey Mercer Date:April 9 1999 9:43pm
Subject:exporting big access file to mySQL corrupts access DB
View as plain text  
I have fairly big table to be exported ( via access97 ) to a mysql DB
running on a remote server. 


Each attempt results in err: (TCX)(MyODBC)Unknown column '110yyyyy' in
'field list'(#1054)

I know that this occurs some 500 records into the save.


Also, after failure, all links from access to mysql are busted and
cannot be restored by rebooting or using the Link Table Manager.

The only thing that seems to work is to delete the bad links and redo
them.

Help!



-- 
Best Regards,

Jeff @ Industrial House

http://www.industrialhouse.com
jmercer@stripped
Thread
exporting big access file to mySQL corrupts access DBJeffrey Mercer10 Apr
  • Re: exporting big access file to mySQL corrupts access DBwebmaster10 Apr
    • How to export Access file to MySQL [Was Re: exporting big access file to mySQL]Naresh Bhagtani12 Apr
      • How to export Access file to MySQL [Was Re: exporting big access file to mySQL]Jani Tolonen14 Apr