Numbers moved Access->SQL server losing decimals

[cdck]

I have an Access database which uses an UPDATE query to store finalized data in a linked SQL server backend. The users work on their data while disconnected from the network in a local Access table, and when it is ready for the Accounting department, they submit the data using the UPDATE query.

My problem is a field which has numbers with decimals. For some reason, the decimals get dropped during the UPDATE query, leaving only the whole numbers preceding them.

The Access field is a Number field with the field size Double, the format General Number, decimal places Auto.

The SQL Server field is numeric, length 9, precision 15, scale 5.

If I type a number with a decimal directly into the SQL server, the decimal stays. If I update the field through the query to match the Access field, the decimal is dropped.

Any ideas?

Cheryl dc Kern

 

[cdck]

Please ignore. I just discovered that the linked table was not updated after the field format was changed on the SQL server. Updating the tables took care of the issue.

Cheryl dc Kern