Problems with field names

[Terry Long]

I'm having trouble with my production environment that I think started after I upgraded to MySql 4.1. To test today I started with a new install and a new database to test - the issue was duplicated

Mysql verion 4.1.7 installled into blank directory (not over existing data directory)
Installed latest ODBC connector 3.51.10 and created a ODBC to the test database.
Created a table named pc_mstr in the default test database:

CREATE TABLE `pc_mstr` (
`id` int(10) NOT NULL auto_increment,
`pc_amt{001}` decimal(10,5) default NULL,
`text` char(10) default NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1

I entered a couple of records then opened MS-Query to test the connection. File, New, add_tables shows the table pc_mstr. I select pc_mstr to add the file to build a query and get the error:

"Can't access table test.pc_mstr".

It seems ODBC with MSQuery, Cognos Impromptu and Crystal Reports all generate this error, which I don't understand.

If I change the column name from pc_amt{001} to pc_amt001, then the table Add works great.

This used to work under MySQL 4.0 - what can I do to get it to work with 4.1 without changing the column names?

Thanks
Terry