Hi there,
I have a SQL Server linked table with a NUMERIC(5,2) datatype and a trigger on that table firing on an Insert or Update which all appears to be working as required as I can use SQL Query Analyzer to view the correct data being stored in the table. The problem is that on creating a database front end in Access using linked tables to link to this table whenever I try to insert or update the data in that table using a form I am receiving the error "Error scaling of decimal value resulted in data truncation".
Can anyone help me resolve this error so I can view the correct decimal data via the form?
Thanks in advance.
I have a SQL Server linked table with a NUMERIC(5,2) datatype and a trigger on that table firing on an Insert or Update which all appears to be working as required as I can use SQL Query Analyzer to view the correct data being stored in the table. The problem is that on creating a database front end in Access using linked tables to link to this table whenever I try to insert or update the data in that table using a form I am receiving the error "Error scaling of decimal value resulted in data truncation".
Can anyone help me resolve this error so I can view the correct decimal data via the form?
Thanks in advance.