Skip to Main Content
Forums

DevOps, CI/CD and Automation

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Wrong data type in MS Access linked table

M.R.Jul 18 2014 — edited Aug 29 2014

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.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 26 2014
Added on Jul 18 2014
#odbc, #windows-and-net
1 comment
2,425 views