database engine error

tom · Post by **tom** » Wed Jun 29, 2005 9:34 am

Hi Jon,
I have a database engine error:
record "0" does not exist in table "thereferences"
after I do a "remove duplicates" (BE detected 2 duplicates). What should I do? rebuild?
tom

Post by **Jon** » Wed Jun 29, 2005 9:51 am

Yes, rebuild...

Jon
Sonny Software

tom · Post by **tom** » Wed Jun 29, 2005 10:24 am

Jon wrote:Yes, rebuild...

done and problem disappeared (uff). do you recommend to do rebuilds regulary (e.g. once per week? or per month?)

Post by **Jon** » Wed Jun 29, 2005 10:38 am

No, although I guess that wouldn't be a bad thing. Personally, I rebuild whenever I encounter an error that I think might be caused by some damage to the index or the database -- this prevents a small problem from becoming compounded into a larger one.

Jon
Sonny Software