connect to other database

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

loizos - 19 Mar 2007 16:25 GMT

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

Reply to this Message

John W. Vinson - 19 Mar 2007 20:36 GMT

>Hi ,
>I Try to connect with sql Database and I am getting the
[quoted text clipped - 4 lines]
>
>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]

Reply to this Message

loizos - 20 Mar 2007 15:16 GMT

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..

> >Hi ,
> >I Try to connect with sql Database and I am getting the
[quoted text clipped - 11 lines]
>
> John W. Vinson [MVP]

Reply to this Message

John W. Vinson - 20 Mar 2007 17:53 GMT

>Hi John,
>I am Using the following steps in order to link with the other
[quoted text clipped - 4 lines]
>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]

Reply to this Message