PDA

View Full Version : Too many indexes when linking from as400 to access



Guest.Visitor
01-13-2004, 09:00 AM
I am trying to link a table from AS400 to access and I get a message box that says; "The operation failed. There are too many indexes in table 'XYZ'. Delete some of the indexes on the table and try the operation again." I can't delete any of the indexes. Why is it saying this and is there anything else I can do? Any help would be appreciated.

David Abramowitz
01-13-2004, 09:00 AM
Try creating a Logical File without any keys, and link the access file to the LF. If you import the data, rather than link, you can set up your own keys within Access. Dave