Forum Stats

  • 3,816,055 Users
  • 2,259,134 Discussions
  • 7,893,374 Comments

Discussions

Wrong data type in MS Access linked table

M.R.
M.R. Member Posts: 36
edited Aug 29, 2014 11:43AM in ODBC

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.

Answers

This discussion has been closed.