Linking Access to SQL tables: Error: Too many indexes on tables

G

Gail H

I am receiving an error when trying to link Access 2003 SP-1 to SQL 2000.
Error: Delete some of the indexes on the table and try the operation again.
The SQL table has 37 indexes and we do not have control or permission to
change these as they are utilized by another program. Is there a way around
this?

Thank you,

Gail
 
A

Alex Dybenko

Hi,
you can try to create a view and link it instead of table. AFAIR - access
has a limit of 32 indexes per table
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

ODBC error 100 when accessing Bookkeeper version 15 software (accounting software using Access dbase) 0
Index with SQL Server Linked Tables 1
Access -> SQL 10
Too Many Indexes Bug 5
Losing SQL Indexes when linking into Access 2000 0
Linked Tables - indexes 4
Link Access 2000 DB to SQL Server 2000 DB 1
ms access table to "dBase IV" with index .cdx 3

Top