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.

user12064840

Hi,

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

Kind regards,

Matthias