At 09:14 PM 12/10/2009, you wrote:

>Hi to All,
>
>I'm a programmer
>
>I'm using an Access 2000 database with Access 2003. I linked some Firebird tables via ODBC. Most tables work just fine, but there's some that give 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 ?

Look at the definitions (data type and precision) of the corresponding columns on each side and figure out what the mismatch is. You might be able to approximate a match by casting one or the other as a varchar. On the other hand, maybe you have a genuine overflow situation that *should* throw an exception that your application will need to handle.

I'd recommend taking your question to firebird-odbc-devel as there might well be some magic checkbox that will deal with the problem in the interface layer. We don't do driver stuff on this list.

^ heLen ^