FredixBlog


Just my log about anything I could find enjoyable.



Index already exists message when linking tables

author Posted by: fredometro on date Jan 6th, 2004 | filed Filed under: MS-Access

Quertion: I receive an error that the index already exists and can not be created when I attempt to link a table to a server database.
The index is needed for updating the linked table. If I remember correctly, when linking with a username with only read rights, there is no index used. So, I suggest you try to link with a read-only user. Access will not attempt to get the PK index.

If this doesn’t work, another way will be using a pass-thru query instead of a linked table. Just create a query, from ‘query’ menu/’sql specific’ choose sql pass thru, and in the statement, simply type: select * from as400table. A pass-thru query is read-only, so doesn’t need PK index for updates. You could also take benefit of it by selecting only the records you need, adding a where clause.

tags