Results 1 to 2 of 2

Error Message Using ODBC To DB2

  1. #1
    JeffGeorge is offline Competent Performer
    Windows 7 64bit Access 2010 64bit
    Join Date
    Jun 2013

    Error Message Using ODBC To DB2

    I'm trying to link to a number of tables on an iSeries DB2 database. Most are working as expected, but for one important table I'm getting the following error message:

    'The operation failed. There are too many indexes on table. Delete some of the indexes on the table and try the operation again.'

    This is an ERP table so modifying the indices is not an option. Is there any other way around this or am I out of luck?

  2. #2
    NTC is offline VIP
    Windows 10 Access 2013
    Join Date
    Nov 2009
    how wide is the table? how many fields? I've not seen this message and of course one can't change the db2 table's properties and so am wondering if it just too big of a table. This is always an issue because connecting a PC database (Access) to a mainframe database there is always the possibility of a payload mismatch, which is what I am guessing is the issue.

    You may need to set up queries or written tables on the DB2 side to create smaller data sets that a PC app can handle and connect to them instead.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Confusing ODBC Error Message
    By Paul H in forum Forms
    Replies: 5
    Last Post: 02-16-2017, 02:26 PM
  2. Replies: 7
    Last Post: 03-17-2016, 04:53 PM
  3. Replies: 1
    Last Post: 03-02-2015, 08:44 AM
  4. Replies: 1
    Last Post: 12-16-2014, 02:48 PM
  5. ODBC timeout message on query
    By thart21 in forum Queries
    Replies: 3
    Last Post: 08-05-2011, 07:54 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
Tech Forums: Microsoft Office Forums