I have been linking to AS400 tables for the past 7 years using MS Access and back coding. All the tables that are needed, which are many, are programmed to open and close when accessing a Form or Report. I know that MS Access has a limitation as to how many indexes can be opened at one time.
Up until this weekend several of my MS Access databases have been running without connection linking error. That is until today, and have now received the following error message:
There are too many indexes on table WFALREP. Delete some of the indexes on the table and try the operation again.
I have had the IBM AS40 admnistrator look into the table to see what indexes are running or IF they can be modified. He is unfamiliar with the indexes and or if they can be modified.
At the present time we are dead-in-the-water.
Does anyone know a workaroudn, if any, or how/where to modify the AS400 table indexes?
I have also tried opening a 'clean' Access db with no success. I am using MS Office 2010.
My SQL 2008 server seems to be connecting and pulling the same table without errors. I cannot use the SQL as a link because the data is static and must be imported daily.