Hi ,

Im getting totally random Corrupt databases with SQL CE.

Are there any precautions i can take against this ?
Is there a way to tell what's causing the problem?

Im doing quite alot of unfriendly things to the database like deleting an entire table and inserting stuff again, but still everything should work , cause one time its giving me no errors at all , next time i use the query analyzer with a big(select statement) it gives error messages.
mzzzz , could it be that the query analyzer reports a message about it being corrupt while it is not , but still locks the .sdf file ?

Im also trying to use the Built in Compacter and repair utility but it keeps saying im missing the SqlCompact30.dll
(where do i put it , anyway)

thx for you help.