booner (com) wrote:
: Have some users who are only comfortable in Access ... so thought of linking
: an Access database to an existing MySQL database. Linking worked fine ...
: when I double click on the table (linked) in Access - brings up data. When
: I got to alter a particular row, field ... I get:
: ODBC -- update on a linked table 'device' failed.
: [Microsoft][ODBC Driver Manager] SQL data type out of range (#0)
: I'm using MySQL 4.1.10
: OS: Windows XP SP2
: Access 2003
: Anyone know what the issue is?
I would compare each column definition as seen in access to the same
column as seen in mysql.
I suspect you'll find that the definition of a column as seen in access
will have a different capability than the corresponding column as seen in
So, for example, if access thinks a number column called THE_PRICE has 32
bits and mysql thinks it has 16 bits then any number access sends will be
too large for mysql.
I guess that this would be most likely for any kind of generic data types
like NUMERIC or TEXT, but I would check all the columns.