"Index already exists" error when attempting to link to AS400 tabl

G

Guest

I have been linking to AS400 tables for some time through Access 97 and Access 2000 -- Suddenly when doing a new database and attempting to link to a table I have used extensively before, I get an Access error that says "Index already exists" and the link fails. I have not made any changes and previous links in other databases using this table appear to be stable. Any suggestions??
 
E

Ernie

Check to make sure that the table definition doesn't have
the Indexed property set as "Yes (No Duplicates)".

It should be either "NO" or "Yes (Duplicates Allowed".

-----Original Message-----
I have been linking to AS400 tables for some time through
Click to expand...
Access 97 and Access 2000 -- Suddenly when doing a new
database and attempting to link to a table I have used
extensively before, I get an Access error that says "Index
already exists" and the link fails. I have not made any
changes and previous links in other databases using this
table appear to be stable. Any suggestions??
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

AS400 connection problems 2
ODBC link to AS400 in Access 2007 2
Beginner: How do I link via ODBC from a PC into an AS400? 7
INDEX ALREADY EXISTS WITH SOME AS400 TABLES 2
Importing an AS400 table 1
Index already exists 1
Exporting Access Tables to AS400 1
Linking Table Error 3

Top