Solved

Access - Unable to link to sql table with too many indexes

Posted on 2016-10-10
4
45 Views
Last Modified: 2016-10-10
Hey guys-
I have some queries that users need to resolve some problems.  
I get the error after trying to link to a sql server table with access.
The error is

The operation failed. There are too nay indexes on table 'Table_name', delete some of the indexes on the table and try the operation again.

Anyway around this without deleting some of the indexes?

Thanks everyone
0
Comment
Question by:jamesmetcalf74
  • 2
4 Comments
 
LVL 47

Accepted Solution

by:
Vitor Montalvão earned 500 total points
ID: 41837021
Looks like it's an Access limitation that only allows a maximum of 32 indexes per table.
0
 
LVL 47

Expert Comment

by:Vitor Montalvão
ID: 41837023
Btw, why do you need more than 32 indexes?
0
 

Author Closing Comment

by:jamesmetcalf74
ID: 41837040
I don't have a clue why this table needs to many indexes.  It's part of a transactional application.
0
 
LVL 65

Expert Comment

by:Jim Horn
ID: 41837067
Might not be a bad idea to reach out and touch the technical owner of the table, smack them upside the head*, and ask them why the eff they need 32 indexes on a table.

*  This comment does not imply any legal protections of any kind.
1

Featured Post

Best Practices: Disaster Recovery Testing

Besides backup, any IT division should have a disaster recovery plan. You will find a few tips below relating to the development of such a plan and to what issues one should pay special attention in the course of backup planning.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Overview: This article:       (a) explains one principle method to cross-reference invoice items in Quickbooks®       (b) explores the reasons one might need to cross-reference invoice items       (c) provides a sample process for creating a M…
This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

770 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question