[AlanChen]

Nathan Anderson wrote on Apr 29 2007, 12:48 AM:

I want to use SQLyog for a scheduled export of some tables/fields from an Access database to mysql on a remote server. In theory everything should work just fine, but I'm having an unfortunate series of problems…

Here is what I'm working with:

Windows XP – fully updated

MS Office 2007 Professional Plus Trial

SQLyog 6.0 Beta 4 Enterprise Trial

Nwind.mdb – Access 2000 version

I installed SQLyog before MS Office but I a vague error stating “Import failed…” when trying to do the migration. I thought that perhaps the problem was that I didn't have Access installed on this computer, so I installed MS Office 2007. Now when I launch SQLyog I get to the trial “nag” screen, but as soon as I click “continue” the whole program crashes and creates a dump file. I then thought perhaps I need to re-install SQLyog, but that appears to have made no difference.

Attached is the most recent dump file…

Any help is appreciated. I'm trying to get a working example so I can get the full version purchased for this project.

Thanks,

Nathan

I think you need to check the mdb file and make sure it is not corrupt. Or you can replace it with your backup. If there is no backup, you can create a new, empty database. Go to File menu-> Get External Data-> Import. Now you can import every valid table. This will give you a clean set of systems tables. If this still doesn't work, you may try some professional services. you can try a utility called Advanced Access Repair to repair your Access MDB file. It works rather well for my corrupt Access MDB files.

Hope this helps.

[Author]

Posts