Issue with Table Links in MS Access 2010

[sesling]

I am running MS Access 2010. There are several Oracle Tables that I was able to link under MS Access 2003 but now that I have upgraded I can no longer link to them. The only thing the tables have in common are that they exceed 3 billion rows. I have no issues linking to other smaller tables in the same Oracle database. The error message I get seems to point to a data issue within the table (numeric value out of range (#0)) However I dont think that is the issue because when I go back to my 2003 MS Access database (which is linked to the same large tables) I am able to query the data. Has anyone seen this same type of issue or have any suggestions on how I can link to these large tables?

[tanvi]

This error occurs for very large tables (2.6 billion + rows), and results when the value returned from the ODBC api call exceeds the maximum value returnable via SQL_C_DEFAULT binding, and the error is expected behavior and indicates the value is too large to fit in the bind.


This is a limitation of Microsoft Access. A potential workaround may be touse DBMS_STATS.SET_TABLE_STATS to alter the data dictionary statistics for the number of rows in the table so that the limit isnot exceeded, but should not be undertaken without understanding the impact. Consult with your DBA for further advice.

[sesling]

Thanks for the information. I will review with our DBA's to see if we can change the DBMS_STATS.SET_TABLE_STATS.