Re: Access to MySQL migration problem

[Clive Johnson]

Hi All,

I think I have the solution: Do you have any indexes called 'Primary'?

If so rename them and it should all work wonderfully..

If you elect to save the table creation SQL and then run it later in the Query Browser you'll see it chokes on the Primary index create call.

I'm seeing this in the SQL generated by the tool:-
...UNIQUE INDEX `Primary` (`ID`),..
rather than
...PRIMARY KEY (`ID`),...

Of course there's nothing to stop you editing the SQL and running it in the Query Browser..

Regards, CliveJ



Edited 1 time(s). Last edit at 06/02/2005 04:17AM by Clive Johnson.