Solved

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

Posted on 2016-10-10
4
54 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
4 Comments
 
LVL 50

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 50

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 66

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

Use Case: Protecting a Hybrid Cloud Infrastructure

Microsoft Azure is rapidly becoming the norm in dynamic IT environments. This document describes the challenges that organizations face when protecting data in a hybrid cloud IT environment and presents a use case to demonstrate how Acronis Backup protects all data.

Question has a verified solution.

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

Access custom database properties are useful for storing miscellaneous bits of information in a format that persists through database closing and reopening.  This article shows how to create and use them.
The Windows Phone Theme Colours is a tight, powerful, and well balanced palette. This tiny Access application makes it a snap to select and pick a value. And it doubles as an intro to implementing WithEvents, one of Access' hidden gems.
In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …
Add bar graphs to Access queries using Unicode block characters. Graphs appear on every record in the color you want. Give life to numbers. Hopes this gives you ideas on visualizing your data in new ways ~ Create a calculated field in a query: …

696 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