Bud Goss
bgoss711 at ameritech.net
Fri Apr 15 13:58:25 CDT 2005
Do not really understand the first paragraph of your e-mail. How can I put the table in design view when I am failing to establish the link to the table in the first place? I attempted the solution discussed in your second paragraph. Went to Tools / Options and cleared out the text box called AutoIndex on Import / Create. I attempted to establish an ODBC to the AS400 to one of my problem tables. Still had the same error message saying Index already exists. Re-booted my PC and tried again. Still no joy. Appreciate your reply. Dan Waters <dwaters at usinternet.com> wrote: Bud, You didn't say if you actually have more than one index in the tables. To find out first put the table in Design view. Then open the Index dialog box by pushing the 'lightening bolt' button. You can delete indexes from here. To stop this from happening go to Tools|Options and click the Tables tab. You'll see a field called AutoIndex on Import/Create. Clear everything out of this field. If something in this field partially matches a name that you've given to a field, then you'll automatically get an index on that field. Check Help to get the whole story. If you manually created an index for the same field, then you may have two indexes with the same name. Perhaps A97 did not have this AutoIndex feature. HTH! Dan Waters -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Bud Goss Sent: Friday, April 15, 2005 11:39 AM 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 -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com