Solved

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

Posted on 2016-10-10
4
40 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 46

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 46

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

Control application downtime with dependency maps

Visualize the interdependencies between application components better with Applications Manager's automated application discovery and dependency mapping feature. Resolve performance issues faster by quickly isolating problematic components.

Question has a verified solution.

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

Introduction The Visual Basic for Applications (VBA) language is at the heart of every application that you write. It is your key to taking Access beyond the world of wizards into a world where anything is possible. This article introduces you to…
Slowly Changing Dimension Transformation component in data task flow is very useful for us to manage and control how data changes in SSIS.
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…
Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.

947 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

Need Help in Real-Time?

Connect with top rated Experts

22 Experts available now in Live!

Get 1:1 Help Now