ODBC -- Too many indexes

nmaxwell-ks
nmaxwell-ks used Ask the Experts™
on
Hi - while trying to import or link to a Sql 2008 table we get the error:
The operation has failed. There are too many indexes on <tablename>.... error 3626

What can be done to workaround this? We need access to this data.

BTW- Using Access 2003 if that matters.
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®

Author

Commented:
Thank you -- I actually came across something similar. But, since I didn't know how to create a view I didn't do anything with it. Is the view created on the SQL server or Access?
It is created in SQL.  Basically a view is going to help you here by creating another way to look at the data in a table without duplicating the data.  Refer to the following document about some basics of views:

http://www.w3schools.com/sql/sql_view.asp

You then would include this view in Access.  The view will take full advantage of the many indexes that are included in the Table, but the indexes won't be on the view, so you should be able to add the view to Access without any trouble.  Depending on your requirements, you could create a view that includes all or just a portion of the original table to fit your needs.

Author

Commented:
Perfect -- created the view and fully resolved the problem. Thank you Sterling.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial