Gordon wrote: >I have been using ACCESS to do simpe data editing on our MySQL tables for 3 >years. > > > >I recently installed 5.0.4 on my machine to evaluate it. I linked the tables >into ACCESS through my old ODBC driver and got > > > >ODBC-update on a linked table 'product_order_choice' failed > >[Microsoft][ODBC Driver Manager] SQL data type out of rance (#0) > > > >I then downloaded and installed the current ODBC connector [3.51.11] >thinking maybe it was my old ODBC copy, but get the same result. > > > >Has anyone else seen this or have any ideas? > > > > It would help if you posted details of the table / data you're working with. 'Data type out of range' usually means you've tried to put a numerical value in a field which is too small. For example, you may be trying to put an int value in a mediumint field. Or it could be that you're using a field type not supported by MS Access, such as an unsigned int or a bigint.
-- Daniel Kasak IT Developer NUS Consulting Group Level 5, 77 Pacific Highway North Sydney, NSW, Australia 2060 T: (+61) 2 9922-7676 / F: (+61) 2 9922 7989 email: [EMAIL PROTECTED] website: http://www.nusconsulting.com.au -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
