MS Access has a "Format" setting for each field. For a numeric field, one of the options is "Percentage". When percentage is selected, the behaviour of the number of decimals changes. For example, with 0 decimals specified, the field will actually store 2 decimals. So, for example, a stored value of 0.05 is displayed as 5%.
The problem is that when retrieving column information via GetSchema, the precision for that example is 0 (actually NULL). This is a problem since the GetSchema information is what I'm using to ensure the user doesn't enter more decimals than can be stored.
Any ideas how to fix this?