Access 2016 64 bit slow to open linked table Oracle 11 g 64 bit

[GForAccessForum]

Good evening, I have a problem with ACCESS 2016 64 bit and Oracle 11g 64 bit. When opening rather large linked oracle tables, the opening is very slow. If instead a pass-through query is launched, the opening is immediate. The same tables opened with windows XP and Access XP with ODBC driver 9 are very fast. Can anyone help me please?

[GForAccessForum]

I have found the problem but i don't know how can i solve. The problem is on the key table definition. If the key is set on varchar2 field the table opening operations is very fast, if the key is set on NUMBER field the table opening operations is very slow.
I create two tables (tot records 5.400.000); the tables are identical except for the primary key which in one case is VARCHAR2 and in the other is NUMBER. The one with the key VARCHAR2 is very fast, the other is very slow.
Anyone have any ideas on this?

[Micron]

cross posted https://www.access-programmers.co.uk...64-bit.310819/

GForAccessForum - please read https://www.excelguru.ca/content.php?184

[GForAccessForum]

The problem can be solved in two ways:
1 - change the type of field on the oracle tables bringing it to NUMBER (10) or VARCHAR (2)
2 - on the configuration of the ODBC set "BIND NUMBER AS FLOAT" = true (BNF=T). In this case it is however necessary to create a new DB and recreate the linked tables.
Thank you all.