Too many indexes to link

  • Thread starter Thread starter KJ Baham
  • Start date Start date
K

KJ Baham

I am trying to link a table from an AS/400 system into MS
Access. This table has too many indexes for MS Access to
accept. My message simply reads: The operation failed.
Ther are too many indexes on table '#######'. Delete some
of the indexes on the table and try again.

I don't have the option to delete the indexes from the
table. Is there another way? Can I make Access ignore the
indexes?
 
You might try one of the following:

1. If possible, create a view in AS/400 of the table and then in Access
link to the view instead of the table. Note that, by default, the linked
view will not be updatable. If you need it to be updatable, you need to
define a "pseudo index" *in Access* to identify which the field(s) whose
values uniquely identify each record. See the "CREATE INDEX Statement" help
topic in Access for more information.

2. If you cannot create a view in AS/400, but you can live with the table
being not updatable, you might try creating a pass-through query in Access
instead of linking to your table (or view). Pass-through queries are not
updatable. See the "Send commands to an SQL database using a pass-through
query" help topic in Access for more information.

Hope this helps.
 
Back
Top