If the primary key in an Access table is a combination of more than one field, the resulting mySQL table has no primary key at all.
Can this be fixed?
Thanks
Search found 3 matches
- Thu Oct 23, 2008 1:05 pm
- Forum: General
- Topic: Primary Key Problem
- Replies: 0
- Views: 12105
- Thu Oct 23, 2008 1:01 pm
- Forum: General
- Topic: Byte fields not handled properly
- Replies: 0
- Views: 10983
Byte fields not handled properly
A byte sized field in Access is unsigned and allows numbers between 0 and 255. When the transfer to mySQL takes place, the result is a signed tinyint(3). This has a range of -127 to +127 or thereabouts. So if any of the original data has a value between 128 and 255 it is rejected and data transfer f...
- Thu Oct 23, 2008 12:43 pm
- Forum: General
- Topic: Foreign keys lost after converting from ACCESS to MySQL
- Replies: 2
- Views: 15824
Re: Foreign keys lost after converting from ACCESS to MySQL
I have the same problem. As far as I can see, there is only one reference to index during the conversion process. I have made sure the tick remains in that box, but still no foreign key settings are created. What am I doing wrong?