1 Reply Latest reply: Aug 29, 2014 10:43 AM by user12064840 RSS

    Wrong data type in MS Access linked table

    M.R.

      Hello,

       

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