Re: Access Migration SQL error 1064

[Tracy Campbell]

Thanks for your response! The error report was coming from MySQL workbench 6.3...4?

But, I did figure out the problem. For some reason it didn't like the comment after INDEX `{80503C8F-1844-4E52-BC34-935DF141BFBB}` (`VialID` ASC)  COMMENT '',
INDEX `VialID` (`VialID` ASC)  COMMENT '',


So I deleted the COMMENT '' to make it look like this:
INDEX `{80503C8F-1844-4E52-BC34-935DF141BFBB}` (`VialID` ASC),
INDEX `VialID` (`VialID` ASC),

And locked the edited scripts that were automatically produced by MySQL workbench.

It had no problem with the previous COMMENT '' commands, so I left those.

The rest of the import steps worked (mostly).