Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 68
  • Last Modified:

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

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
jamesmetcalf74
Asked:
jamesmetcalf74
  • 2
1 Solution
 
Vitor MontalvãoMSSQL Senior EngineerCommented:
Looks like it's an Access limitation that only allows a maximum of 32 indexes per table.
0
 
Vitor MontalvãoMSSQL Senior EngineerCommented:
Btw, why do you need more than 32 indexes?
0
 
jamesmetcalf74Author Commented:
I don't have a clue why this table needs to many indexes.  It's part of a transactional application.
0
 
Jim HornMicrosoft SQL Server Developer, Architect, and AuthorCommented:
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now