Detect Database corruption in Access

[rmatthew]

I have an application that uses an access database. It appears that sometimes Access gets corrupt (go figure - no news here). In any case - I need to detect the corruption. Any ideas?

 

I thought about doing a compact and repair and checking wheather it was successful or not - but I do not see a return value for the function??

 

Any help is greatly appreciated.

[Robby]

As far as detecting the corruption, there is no exact way to do this, you can trap it in your Try/Catch.

 

I haven't tried compacting in .NET, but for sure if it is not successfull you will again trap it in the Try/Catch. ( Unless the method has its' own exception handling in which case you would take that route in your Catch.)