Error Linking External Table

[mcgowan.b]

Hi

I'm trying to link to an ODBC table in access. When I do though, I get an error message saying 'The Operation Failed. There are too many indexes on the table 'My Table' Delete some of these indexes and try again' There are currently circa 120 fields on this table.

The ODBC connection I have is read only and the table 'My Table' is the primary table of my database. Is there a way round this to select only the fields that I want on the table to come back into access?

[Rainlover]

Are you linking Access to Access or something else.

[mcgowan.b]

Access to an SQL Database via ODBC

[Rainlover]

I have never experience this problem before.

Also I have never experienced a Table with 120 Fields.

You need to look at your design. Search Normalisation.

[mcgowan.b]

I have never experience this problem before.

Also I have never experienced a Table with 120 Fields.

You need to look at your design. Search Normalisation.

The Database is provided to us by a thrid party, and so our connection to it is read only. There are a lot of fields in the table, but I would only need about 25 of them max. is there a way to link to the table but only use fields that I want?

[Rainlover]

What happens is that you link to the Table not to the Fields.

I am a MySQL person and not very experienced with SQL Server.

Do you have the correct driver?

[mcgowan.b]

What happens is that you link to the Table not to the Fields.

I am a MySQL person and not very experienced with SQL Server.

Do you have the correct driver?

Yes, i have the correct driver and can link other tables from the database fine. When I try to link to the table I want 'incidents' I get the attached message

[Rainlover]

There appears to be no simple solution.

The maximum number of indexes is 32.

Have a look at this link.

http://office.microsoft.com/assistan...EC010227011033

I believe you could create a Query to get around this problem.

Again this is a new thing for me.

I would suggest that you Google for more help.

I am 99% sure this is possible, but I simply have not done this.

[mcgowan.b]

Is it possible to import a table without indexing all the fields, or only indexing the ones I want?

[Rainlover]

Maybe you could do this with a query.

I will do some research tomorrow but no promises.