I have this problem, been trying to get to the bottom of it for over a year now. Hoped it would go with windows 6.5++. It is always the same table. It started with a PK on a computed column, I changed the computed column for a real column to no avail. Even tried a unique key, again still got the problem.
What happens is the index gets corrupt during the normal working day in multi user mode. Records are only deleted from the table. Overnight in single user mode records are added to the table using code to check for duplication by checking the key column, as this is indexed and the index is corrupt the check fails adding a duplicated record to the table. Again overnight, a reload takes place which works but also maintaining the corrupt index. If you watch the reload running you see a duplicated record error appear. After a reload the column is still described as being indexed. Ian At 16:28 27/09/2001 -0700, you wrote: >I do lock the table & if the table won't lock, then someone has some type of >lock (usually an edit lock) so it informs the user to have others in the >dept to exit the table and then the user can try the program with the append >operation again. It appears that the index problem exists BEFORE the append >is attempted. Trying the append just reports that there is an indexing >problem. As users, throughout the day add/edit rows in the accounting >table, the indexes will get updated, thus, the indexes for this table (as >well as many other tables) are in a constant state of flux. > >I have indexes on computed columns in other tables that are accessed by >everyone and haven't had problems with those tables. > >My questions again are: What can cause the corruption of the indexes on the >table and how can I discover which index or indexes on the table are >corrupted. > > > >-----Original Message----- >From: Troy Sosamon [mailto:[EMAIL PROTECTED]] >Sent: Thursday, September 27, 2001 9:09 AM >To: [EMAIL PROTECTED] >Subject: RE: Index corruption > > >Try putting a lock manual on the table before you do the append and then >take it off. > >set lock tablename on > >append..... > >set lock tablename off > >Troy
