Linked Foxpro table error : Decimal field precision too small
Posted on 2004-11-09
I'm using an Access 2000 database with Access 2003 SP1. I linked some Foxpro tables via ODBC. Most tables work just fine, but there's one that gives me the error "The decimal field's precision is too small to accept the numeric you attempted to add."
This error occurs on just a few records. I'm able to open the table and see my data except for those few records, they show as "#Error"
I need these tables to be linked and can't change their design as they are used be another application wich can't be updated...
Any ideas ?