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 |
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
 Posted - 2003-03-10 : 07:44:49
|
| I have a problem whereby numerics of a precision of 38 and a scale of 9 are showing and being interpreted in Access 2002 as text fields.I am using Linked tables over an ODBC connection to a SQL Server 2000 Database.If anyone has had this problem and knows a way around it please tell me as it's driving me mad at the moment... :) |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2003-03-10 : 08:48:49
|
| The biggest number Access can handle is decimal up to 28 digits. It cannot properly deal with numbers with higher settings. ODBC (I believe) also maxes out at 28 digits, but it wouldn't matter if it could go higher anyway. If you really don't need 38 digits and 9 decimal places you can knock the precision down to something Access can handle. |
 |
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2003-03-10 : 09:13:31
|
| Cheers Rob.. :) |
|
|
|
|
|
|
Numeric Data & Linked Tables using ODBC drivers