Perry Harold
pharold at proftesting.com
Fri Apr 15 14:59:05 CDT 2005
Do you perhaps have an index set to something generic like Name (rather than FullName, CustName, EmpName, eg). If so you might have to make the connection with A97 and rename the index to a more specific index. Then A2003 might allow you to make the connection. Name, etc have become reserved terms in many instances and may cause conflicts with indexes in newer versions. Perry Harold -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Bud Goss Sent: Friday, April 15, 2005 12:39 PM To: accessd at databaseadvisors.com Subject: [AccessD] Use if HIT ODBC/400 with Access 2003 - X Posted Greetings from a long time ACCESSD lurker I have used the HIT Software Inc with Access 97 databases to establish links to our AS400 tables for quite a while. When I attempt to use this software with an Access 2003 database to establish an ODBC link to our AS400 ( for many - not all - tables ) the system will not create an ODBC link. The message I get is Index already exists. Pressing Help gives the message "Index already exists. (Error 3284)" You cannot have two indexes with the same name in a table. Rename one of the indexes. But I can take the same table and establish an ODBC link with an Access 97 database. I have attempted to do this on several Access 2003 databases ( Including a new totaly empty Access 2003 database) and have the same problem. I have sent HIT Software trace files for this situation.They have not yet been able to determine the cause of this anomoly. I suspect that the problem is in Access 2003 rather than with anything in our AS400. Has anyone else run into this problem? If so, do you have a solution. -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com