1 Reply Latest reply on Aug 29, 2014 3:43 PM by user12064840

    Wrong data type in MS Access linked table




      I installed 32-bit Oracle Data Access Components (ODAC) version (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.