Hi,
I am importing an Access 97 Database into MySQL.
One of tables tblSuppliers holds all the critical supplier information and has a 4
character Primary key called 'Key'
This is heavily used throughout a lot of VB code in the Access GUI and can't really be
changed easily.
When I import the Access tables into MYSQL, they lose their indexes and primary keys.
Try as I might, I can't change the properties of the Key column using Alter Table, it
keeps coming back with syntax errors.
I'm currently stuck on the following,
ALTER TABLE tblSuppliers CHANGE Key Key CHAR(6) NOT NULL
What am I doing wrong/ is there a work round?
Thanks in advance for you help.
Richard Harris
