Re: The decimal field's precision is too small--when making query by access

[Mike Hillyer]

If you moved from Access to MySQL there is a good change you have no INDEX information in the MySQL tables.

Try adding an INDEX to the Address column:

ALTER TABLE table_name ADD INDEX (Adress);

See http://dev.mysql.com/doc/mysql/en/ALTER_TABLE.html for more information.

Mike Hillyer, Technical Writer
MySQL AB, www.mysql.com
Office: [phone]

Blog: http://www.openwin.org/mike

"The Open Source movement has become a major force across the software industry, and MySQL is the world's most popular open source database."
--Fortune Magazine