Ian,
How are the records deleted. Is this done from a form, from a prompt, or
from the edit screen?
Randy Peterson
Ian Stone wrote:
> 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
