Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Hommer
Aged Yak Warrior
808 Posts |
 Posted - 2006-04-20 : 15:09:29
|
| Hi!I have found this strange behavior in Access linked tables to SQL Server. The data type defined as decimal in sql, but showing up in access as text! Not only it shows as text under design view, but also access wouldn't run aggregate query, for instance, sum() on this column. The error message says Jet Engine could not execute the sql statement because it contains a field that has an invalid data type.And, I found out, if the decimal data type is of a precision of 10, Access will interpretate it as number, but the default precision of 18 will make the linked field of data type text! Ouch! I guess when decimal being defined is too big for access, it chooses the largest box available, which is text in this case. Just to share my boservation. BTY, this is under ac97. |
|
|
blindman
Master Smack Fu Yak Hacker
2365 Posts |
Posted - 2006-04-20 : 15:47:00
|
| Interesting. I haven't run into that before. |
 |
|
|
|
|
|
Different interpretation of data type