I installed 32-bit Oracle Data Access Components (ODAC) version 220.127.116.11.2 (latest). I am using Oracle 11g R2
I created an Oracle table that has an INTEGER field, DEFAULT value = 0
I then created a linked table in MS Access (version 2010)
However, if I switch to Table Design view in Access, I can see this field is considered by Access as TEXT size 38.
What is the solution as we cannot properly design our Access queries?
Thank you, M.R.
Integer datatype will use a precision of 38, which is indeed mapped to text is Access. Try NUMBER(9,0) instead of integer.
The mapping of Oracle datatypes to Access datatypes is documented here: ACC: Conversion of ORACLE Data Types to Microsoft Access