[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 64
  • 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

Featured Post

Get quick recovery of individual SharePoint items

Free tool – Veeam Explorer for Microsoft SharePoint, enables fast, easy restores of SharePoint sites, documents, libraries and lists — all with no agents to manage and no additional licenses to buy.

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