Reserved word/ Ambiguous Column title 'Key'

2001-03-28 Thread Richard Harris
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

Re: Reserved word/ Ambiguous Column title 'Key'

2001-03-28 Thread Lindsay Adams
Somebody will correct me if I am wrong, but I think cannot have a column in a table that has the same name as a MySQL reserved word. You are going to have to change it. 'Key' is simply NOT going to work for your column name. On the reasonable chance that I am wrong, the documentation that I am