Recent content by 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...

I would have been wrong to publish only the eventual final solution, as I did for the partial one. Thank you and excuse me.

I'm sorry, but on 04-07-2020 i post my messagge in Access Forums and I have not received any response. On 04-14-2020 (seven days later) i post my message here. I honestly didn't think of removing the post from the other forum. I thought it correct to let the other group know what the theme was...

Yes, i identify the primary key. 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.

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. Anyone have any ideas on this?

Thanks for the replies. Opening the whole table is useful to immediately apply the filters and see the contents of the fields before setting up any queries. In addition, queries are very slow even using indexes. With pass-through query this does not occur. I thought of a slowdown due to the...

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 (some minute o open). If instead a pass-through query (like select * from <table>) is launched, the opening is immediate. The same tables opened...