Cannot link to table with more than 32 indexes

[Jim]

I am trying to use an ODBC link to a SQL Server database
but I get Error 3626: "The operation failed. There are
too many indexes on table <name>. Delete some of the
indexes on the table and try the operation again." The
tables are not mine and so I cannot change them. Is there
any way around this?

 

[Brian Camire]

Your might try one of the following:

1. Create a view in SQL Server 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 can define a "pseudo
index" *in Access* to identify which the field(s) whose values uniquely
identify
each record. See the CREATE INDEX help topic in Access for more
information.

2. If for some reason you are not able to create a view in SQL Server, 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.

Hope this helps.