Gary Kjos
garykjos at gmail.com
Wed Apr 20 08:22:46 CDT 2005
Good job figuring it out Bud and thanks for sharing the solution. I used to work with AS/400 data but it's close ten years ago now. Perhaps I will again. My current employer does use an AS/400 for some warehouse operations stuff in one of our locations, but I haven't been called on to access it at all. Gary On 4/19/05, Bud Goss <bgoss711 at ameritech.net> wrote: > I initially named this topic Use if (typo should be "of" not "if") > HIT ODBC/400 with Access 2003 > > I have renamed this solution post because the problem is not exclusive to the HIT Software ODBC driver. It will occur also occur with IBM's iSeries Access driver- and probably others as well. > > If you encounter this (getting a message that an "Index Aready Exists") when working with an Access 2003 database refer to the following Microsoft Knowledge Base articles > > 811963 > 870753 > 837001 > > With my Hit software, I learned that the problem can be by-passed by un-checking the SQLStasistics option. > > With the iSeries software, a couple of hotfix installs are required.I have not actually installed the hotfixs on a test machine yet, but am reasonably confident that this will resolve the issue. > > Thanks to all who commented.. > > -- > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > Website: http://www.databaseadvisors.com > -- Gary Kjos garykjos at gmail.com