How to delete index on odbc-linked database?

[c.a.duevel]

Hello!

I have a really weird problem, here:

I'll have to link tables of a sql server 2005 database to an access
2003 database.
This works without a problem, but those linked tables get up to five
(!) primary keys -
NONE of them is defined as a primary key in the server database.

I tried anything I could think of in DAO and ADO, to delete those keys
- without any success.
Has somebody ever done this and knows how it is possible?

Any help is appreciated!

Thanks a bunch,

Carl

[JvC]

You need to use an ADO command object to execute the SQL on the server. You
have to have administrator rights to drop an index.

If I remember correctly it goes something like:

set cmd = New adodb.command
set md.connnection.activeconnection = myadodbconnection
cmd.commandtext = "drop myindex on mydatabase.mytable
cmd.Execute

John

<c.********@googlemail.comwrote in message
news:0f**********************************@z66g2000 hsc.googlegroups.com...

Hello!

I have a really weird problem, here:

I'll have to link tables of a sql server 2005 database to an access
2003 database.
This works without a problem, but those linked tables get up to five
(!) primary keys -
NONE of them is defined as a primary key in the server database.

I tried anything I could think of in DAO and ADO, to delete those keys
- without any success.
Has somebody ever done this and knows how it is possible?

Any help is appreciated!

Thanks a bunch,

Carl

[Roger]

On Jun 14, 11:27*am, "[e-mail]"
<[e-mail]:

Hello!

I have a really weird problem, here:

I'll have to link tables of a sql server 2005 database to an access
2003 database.
This works without a problem, but those linked tables get up to five
(!) primary keys -
NONE of them is defined as a primary key in the server database.

I tried anything I could think of in DAO and ADO, to delete those keys
- without any success.
Has somebody ever done this and knows how it is possible?

Any help is appreciated!

Thanks a bunch,

Carl

so you have an sql table with just one primary key, and when you link
it in access, you more than one primary key ?
or do you get the same primary key and some indexes ?