Forum Discussion
MS Access Data Type Number Greater Than 28
When linking via ODBC to Snowflake, field is Number(38,0) and is linking at Short Text. I thought Large Number Data Type would be the answer, but Microsoft says no and to recommend to their Engineer...
There is no way to handle these in Access. Maximum for Decimal is, as you have found out, 28 digits. The only option would be to manipulate those number via Pass-Through queries.