Bob,

I don't know the MM framework at all, so I apologize in advance if this wastes your time...

You may want to review the thread #580276. Messages #583143 and #583677 may be of particular interest.

I **assume** that neither the records nor their index values are there when the problem occurs.

good luck


PS You said that you were new to UT, so I want to let you know that you should be able to simply click on the thread# or message#s above to see them.


>Jason,
>
>The datetime column was not a PK. Also, I use views for all my database activities and do not use tables directly. Additionally, I do occasionally have problems with indexes but it is always fixed with a Pack/ReIndex. The exception of course is with this one table/view.
>
>I had mentioned last time that deleting the index file fixed the problem, however, it got fixed after that by deleting one row and packing the table. Not deleting the row and issuing the Pack did not fix the problem.
>
>I'll try some of your suggestions, to see if it sheds some light. Either way, thanks for your help on this. I hope some day I can return the favor.
>Of course, if the puzzle is solved I will post the solution.
>
>Best regards.