connect to other database

[Guest]

Hi ,
I Try to connect with sql Database and I am getting the
Message." Two many indexes on that table.Delete some of them and
try again."
I am using access 2003.
Is any other way to connect with that table???

Pls Help

 

[John W. Vinson]

Hi ,
I Try to connect with sql Database and I am getting the
Message." Two many indexes on that table.Delete some of them and
try again."
I am using access 2003.
Is any other way to connect with that table???

Pls Help

You may need to create a View on the table (within SQL/Server) and connect to
that View instead. I don't know if there's any pure-Access solution!

How are you trying to do the connection?

John W. Vinson [MVP]

 

[Guest]

Hi John,
I am Using the following steps in order to link with the other
database.
From File ->Get External data->Link Tables
and then I use ODBC .
For some table I establish the Link.
But For A specific table I Can not.
The message is "Two many indexes.."
Thanks..

 

[John W. Vinson]

Hi John,
I am Using the following steps in order to link with the other
database.
From File ->Get External data->Link Tables
and then I use ODBC .
For some table I establish the Link.
But For A specific table I Can not.
The message is "Two many indexes.."

I'd suggest posting a question in microsoft.public.access.sqlupsizing - some
of the folks there have a lot of experience with the Access/SQL interface. Do
you have permission - or know someone who does - to open the table in design
view in SQL's Enterprise Manager? How many indexes ARE there on this monster
(Access should allow 32, and I wasn't aware that the limit applied to linked
external tables)?


John W. Vinson [MVP]